SELECT`country`.`id`FROM`country`LEFT JOIN`sales_channel_country``country.salesChannels.mapping`ON`country`.`id`=`country.salesChannels.mapping`.`country_id`LEFT JOIN`sales_channel``country.salesChannels`ON`country.salesChannels.mapping`.`sales_channel_id`=`country.salesChannels`.`id`WHERE ((`country.salesChannels`.`id`=?)) AND (`country`.`id`IN (?)) GROUP BY`country`.`id`
SELECT`country`.`id`FROM`country`LEFT JOIN`sales_channel_country``country.salesChannels.mapping`ON`country`.`id`=`country.salesChannels.mapping`.`country_id`LEFT JOIN`sales_channel``country.salesChannels`ON`country.salesChannels.mapping`.`sales_channel_id`=`country.salesChannels`.`id`WHERE
(
(`country.salesChannels`.`id`=?)
)
AND (
`country`.`id`IN (?)
)
GROUP BY`country`.`id`
SELECT`country`.`id`FROM`country`LEFT JOIN`sales_channel_country``country.salesChannels.mapping`ON`country`.`id`=`country.salesChannels.mapping`.`country_id`LEFT JOIN`sales_channel``country.salesChannels`ON`country.salesChannels.mapping`.`sales_channel_id`=`country.salesChannels`.`id`WHERE ((`country.salesChannels`.`id`=0x6C889B917EF14E05BB6083F2C55190C5)) AND (`country`.`id`IN (0x797F8A2DF3D44C2E8DB5A20E88149C68)) GROUP BY`country`.`id`;
SELECTLOWER(HEX(`category`.`parent_id`)) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE (`category`.`version_id`=?) AND ((`category`.`path`LIKE?AND`category`.`level`=?AND`category`.`active`=?AND`category`.`visible`=?)) GROUP BY`category`.`parent_id`
SELECTLOWER(
HEX(`category`.`parent_id`)
) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE
(`category`.`version_id`=?)
AND (
(
`category`.`path`LIKE?AND`category`.`level`=?AND`category`.`active`=?AND`category`.`visible`=?
)
)
GROUP BY`category`.`parent_id`
SELECTLOWER(HEX(`category`.`parent_id`)) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE (`category`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path`LIKE'%|653bb020fe1548028338676c4161f550|%'AND`category`.`level`=4AND`category`.`active`=1AND`category`.`visible`=1)) GROUP BY`category`.`parent_id`;
SELECTLOWER(HEX(`category`.`parent_id`)) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE (`category`.`version_id`=?) AND ((`category`.`path`LIKE?AND`category`.`level`=?AND`category`.`active`=?AND`category`.`visible`=?)) GROUP BY`category`.`parent_id`
SELECTLOWER(
HEX(`category`.`parent_id`)
) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE
(`category`.`version_id`=?)
AND (
(
`category`.`path`LIKE?AND`category`.`level`=?AND`category`.`active`=?AND`category`.`visible`=?
)
)
GROUP BY`category`.`parent_id`
SELECTLOWER(HEX(`category`.`parent_id`)) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE (`category`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path`LIKE'%|1c0eda83883448f08125143bbb360c89|%'AND`category`.`level`=3AND`category`.`active`=1AND`category`.`visible`=1)) GROUP BY`category`.`parent_id`;
SELECTLOWER(HEX(`category`.`parent_id`)) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE (`category`.`version_id`=?) AND ((`category`.`path`LIKE?AND`category`.`level`=?AND`category`.`active`=?AND`category`.`visible`=?)) GROUP BY`category`.`parent_id`
SELECTLOWER(
HEX(`category`.`parent_id`)
) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE
(`category`.`version_id`=?)
AND (
(
`category`.`path`LIKE?AND`category`.`level`=?AND`category`.`active`=?AND`category`.`visible`=?
)
)
GROUP BY`category`.`parent_id`
SELECTLOWER(HEX(`category`.`parent_id`)) as`category-ids.key`,COUNT(`category`.`id`) as`category-ids.count`,COUNT(DISTINCT`category`.`id`) as`visible-children-count`FROM`category`WHERE (`category`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path`LIKE'%|8cf386005d164c2c9c8431efe52e6146|%'AND`category`.`level`=4AND`category`.`active`=1AND`category`.`visible`=1)) GROUP BY`category`.`parent_id`;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`IN (?,?,?,?,?,?,?,?,?,?)))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`IN (?,?,?,?,?,?,?,?,?,?)
)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`IN (0x13E88C68E518483395C4B62C2B32D19D,0x14D993643DB94CC291C727A590C0819B,0x2EF935EE014248F486CB26A9C3C6EACF,0x3EFFB08F60EF40E693E2F3BE48B18B6E,0x57EF33A14E6B46B7ADF9EF913913075B,0x7F1FA708D14B461F9BE08BDE2B791A09,0x83326780CA9F4BACA829677823C051C7,0xB460DA71668140D1A190B8B5AFF05D08,0xB9A372AB3031490CB23B527336F2AE64,0xEFEE33909F444317AD5F3E0D1476B7AB)));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x7F1FA708D14B461F9BE08BDE2B791A09AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x7F584F3992314818A11F11A996F05643));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xEFEE33909F444317AD5F3E0D1476B7ABAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xA210AAA6E9E842298FF843444208210E));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x57EF33A14E6B46B7ADF9EF913913075BAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x3CF0E749871343E592B0F35907828929));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x83326780CA9F4BACA829677823C051C7AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xC4FF95C30A66435F8752886A939170D8));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x13E88C68E518483395C4B62C2B32D19DAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x233B5992A6C64550A5DD9E722F573279));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x2EF935EE014248F486CB26A9C3C6EACFAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xA2A15777360948B4A5ED7449D4A170D9));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x14D993643DB94CC291C727A590C0819BAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x234448EDE6C249D0B3FD29863F2C5E22));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xB460DA71668140D1A190B8B5AFF05D08AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x107AA1ED990C405DA6810DA63FB0891C));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x3EFFB08F60EF40E693E2F3BE48B18B6EAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xF51A5CF4A27849899B17F6025DDAA6A7));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xB9A372AB3031490CB23B527336F2AE64AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xCBE7100C68F248828A7F59574414E1E6));
SELECT`product`.`id`,`product`.`product_number`,`product`.`auto_increment`FROM`product`LEFT JOIN`product``product.parent`ON`product`.`parent_id`=`product.parent`.`id`AND`product`.`parent_version_id`=`product.parent`.`version_id`LEFT JOIN`product_visibility``product.visibilities`ON`product`.`visibilities`=`product.visibilities`.`product_id`AND`product`.version_id=`product.visibilities`.product_version_idLEFT JOIN (SELECT`product.translation`.product_id,`product.translation`.product_version_id,`product.translation`.meta_descriptionas`product.translation.metaDescription`,`product.translation`.nameas`product.translation.name`,`product.translation`.keywordsas`product.translation.keywords`,`product.translation`.descriptionas`product.translation.description`,`product.translation`.meta_titleas`product.translation.metaTitle`,`product.translation`.pack_unitas`product.translation.packUnit`,`product.translation`.pack_unit_pluralas`product.translation.packUnitPlural`,`product.translation`.custom_search_keywordsas`product.translation.customSearchKeywords`,`product.translation`.slot_configas`product.translation.slotConfig`,`product.translation`.custom_fieldsas`product.translation.customFields`,`product.translation`.created_atas`product.translation.createdAt`,`product.translation`.updated_atas`product.translation.updatedAt`,`product.translation`.product_idas`product.translation.productId`,`product.translation`.language_idas`product.translation.languageId`,`product.translation`.product_version_idas`product.translation.productVersionId`FROM`product_translation``product.translation`WHERE`product.translation`.language_id=?) `product.product_translation`ON`product.product_translation`.`product_id`=`product`.`id`AND`product.product_translation`.product_version_id=`product`.version_idLEFT JOIN (SELECT`product.parent.translation`.product_id,`product.parent.translation`.product_version_id,`product.parent.translation`.meta_descriptionas`product.parent.translation.metaDescription`,`product.parent.translation`.nameas`product.parent.translation.name`,`product.parent.translation`.keywordsas`product.parent.translation.keywords`,`product.parent.translation`.descriptionas`product.parent.translation.description`,`product.parent.translation`.meta_titleas`product.parent.translation.metaTitle`,`product.parent.translation`.pack_unitas`product.parent.translation.packUnit`,`product.parent.translation`.pack_unit_pluralas`product.parent.translation.packUnitPlural`,`product.parent.translation`.custom_search_keywordsas`product.parent.translation.customSearchKeywords`,`product.parent.translation`.slot_configas`product.parent.translation.slotConfig`,`product.parent.translation`.custom_fieldsas`product.parent.translation.customFields`,`product.parent.translation`.created_atas`product.parent.translation.createdAt`,`product.parent.translation`.updated_atas`product.parent.translation.updatedAt`,`product.parent.translation`.product_idas`product.parent.translation.productId`,`product.parent.translation`.language_idas`product.parent.translation.languageId`,`product.parent.translation`.product_version_idas`product.parent.translation.productVersionId`FROM`product_translation``product.parent.translation`WHERE`product.parent.translation`.language_id=?) `product.product_translation.parent`ON`product.product_translation.parent`.`product_id`=`product.parent`.`id`AND`product.product_translation.parent`.product_version_id=`product.parent`.version_idWHERE (`product`.`version_id`=?) AND (((((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?)) OR ((`product`.`id`=?OR`product`.`parent_id`=?))) ANDNOT (`product`.`display_group`<=>?) AND ((`product.visibilities`.`visibility`>=?) AND`product.visibilities`.`sales_channel_id`=?ANDIFNULL(`product`.`active`,`product.parent`.`active`) =?))) GROUP BY`product`.`display_group`ORDER BYMAX(COALESCE(`product.translation.name`,`product.parent.translation.name`)) DESCLIMIT50
SELECT`product`.`id`,`product`.`product_number`,`product`.`auto_increment`FROM`product`LEFT JOIN`product``product.parent`ON`product`.`parent_id`=`product.parent`.`id`AND`product`.`parent_version_id`=`product.parent`.`version_id`LEFT JOIN`product_visibility``product.visibilities`ON`product`.`visibilities`=`product.visibilities`.`product_id`AND`product`.version_id=`product.visibilities`.product_version_idLEFT JOIN (
SELECT`product.translation`.product_id,`product.translation`.product_version_id,`product.translation`.meta_descriptionas`product.translation.metaDescription`,`product.translation`.nameas`product.translation.name`,`product.translation`.keywordsas`product.translation.keywords`,`product.translation`.descriptionas`product.translation.description`,`product.translation`.meta_titleas`product.translation.metaTitle`,`product.translation`.pack_unitas`product.translation.packUnit`,`product.translation`.pack_unit_pluralas`product.translation.packUnitPlural`,`product.translation`.custom_search_keywordsas`product.translation.customSearchKeywords`,`product.translation`.slot_configas`product.translation.slotConfig`,`product.translation`.custom_fieldsas`product.translation.customFields`,`product.translation`.created_atas`product.translation.createdAt`,`product.translation`.updated_atas`product.translation.updatedAt`,`product.translation`.product_idas`product.translation.productId`,`product.translation`.language_idas`product.translation.languageId`,`product.translation`.product_version_idas`product.translation.productVersionId`FROM`product_translation``product.translation`WHERE`product.translation`.language_id=?
) `product.product_translation`ON`product.product_translation`.`product_id`=`product`.`id`AND`product.product_translation`.product_version_id=`product`.version_idLEFT JOIN (
SELECT`product.parent.translation`.product_id,`product.parent.translation`.product_version_id,`product.parent.translation`.meta_descriptionas`product.parent.translation.metaDescription`,`product.parent.translation`.nameas`product.parent.translation.name`,`product.parent.translation`.keywordsas`product.parent.translation.keywords`,`product.parent.translation`.descriptionas`product.parent.translation.description`,`product.parent.translation`.meta_titleas`product.parent.translation.metaTitle`,`product.parent.translation`.pack_unitas`product.parent.translation.packUnit`,`product.parent.translation`.pack_unit_pluralas`product.parent.translation.packUnitPlural`,`product.parent.translation`.custom_search_keywordsas`product.parent.translation.customSearchKeywords`,`product.parent.translation`.slot_configas`product.parent.translation.slotConfig`,`product.parent.translation`.custom_fieldsas`product.parent.translation.customFields`,`product.parent.translation`.created_atas`product.parent.translation.createdAt`,`product.parent.translation`.updated_atas`product.parent.translation.updatedAt`,`product.parent.translation`.product_idas`product.parent.translation.productId`,`product.parent.translation`.language_idas`product.parent.translation.languageId`,`product.parent.translation`.product_version_idas`product.parent.translation.productVersionId`FROM`product_translation``product.parent.translation`WHERE`product.parent.translation`.language_id=?
) `product.product_translation.parent`ON`product.product_translation.parent`.`product_id`=`product.parent`.`id`AND`product.product_translation.parent`.product_version_id=`product.parent`.version_idWHERE
(`product`.`version_id`=?)
AND (
(
(
(
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
OR (
(
`product`.`id`=?OR`product`.`parent_id`=?
)
)
)
ANDNOT (`product`.`display_group`<=>?)
AND (
(
`product.visibilities`.`visibility`>=?
)
AND`product.visibilities`.`sales_channel_id`=?ANDIFNULL(
`product`.`active`,`product.parent`.`active`
) =?
)
)
)
GROUP BY`product`.`display_group`ORDER BYMAX(
COALESCE(
`product.translation.name`,`product.parent.translation.name`
)
) DESCLIMIT50
SELECT`product`.`id`,`product`.`product_number`,`product`.`auto_increment`FROM`product`LEFT JOIN`product``product.parent`ON`product`.`parent_id`=`product.parent`.`id`AND`product`.`parent_version_id`=`product.parent`.`version_id`LEFT JOIN`product_visibility``product.visibilities`ON`product`.`visibilities`=`product.visibilities`.`product_id`AND`product`.version_id=`product.visibilities`.product_version_idLEFT JOIN (SELECT`product.translation`.product_id,`product.translation`.product_version_id,`product.translation`.meta_descriptionas`product.translation.metaDescription`,`product.translation`.nameas`product.translation.name`,`product.translation`.keywordsas`product.translation.keywords`,`product.translation`.descriptionas`product.translation.description`,`product.translation`.meta_titleas`product.translation.metaTitle`,`product.translation`.pack_unitas`product.translation.packUnit`,`product.translation`.pack_unit_pluralas`product.translation.packUnitPlural`,`product.translation`.custom_search_keywordsas`product.translation.customSearchKeywords`,`product.translation`.slot_configas`product.translation.slotConfig`,`product.translation`.custom_fieldsas`product.translation.customFields`,`product.translation`.created_atas`product.translation.createdAt`,`product.translation`.updated_atas`product.translation.updatedAt`,`product.translation`.product_idas`product.translation.productId`,`product.translation`.language_idas`product.translation.languageId`,`product.translation`.product_version_idas`product.translation.productVersionId`FROM`product_translation``product.translation`WHERE`product.translation`.language_id=0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation`ON`product.product_translation`.`product_id`=`product`.`id`AND`product.product_translation`.product_version_id=`product`.version_idLEFT JOIN (SELECT`product.parent.translation`.product_id,`product.parent.translation`.product_version_id,`product.parent.translation`.meta_descriptionas`product.parent.translation.metaDescription`,`product.parent.translation`.nameas`product.parent.translation.name`,`product.parent.translation`.keywordsas`product.parent.translation.keywords`,`product.parent.translation`.descriptionas`product.parent.translation.description`,`product.parent.translation`.meta_titleas`product.parent.translation.metaTitle`,`product.parent.translation`.pack_unitas`product.parent.translation.packUnit`,`product.parent.translation`.pack_unit_pluralas`product.parent.translation.packUnitPlural`,`product.parent.translation`.custom_search_keywordsas`product.parent.translation.customSearchKeywords`,`product.parent.translation`.slot_configas`product.parent.translation.slotConfig`,`product.parent.translation`.custom_fieldsas`product.parent.translation.customFields`,`product.parent.translation`.created_atas`product.parent.translation.createdAt`,`product.parent.translation`.updated_atas`product.parent.translation.updatedAt`,`product.parent.translation`.product_idas`product.parent.translation.productId`,`product.parent.translation`.language_idas`product.parent.translation.languageId`,`product.parent.translation`.product_version_idas`product.parent.translation.productVersionId`FROM`product_translation``product.parent.translation`WHERE`product.parent.translation`.language_id=0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation.parent`ON`product.product_translation.parent`.`product_id`=`product.parent`.`id`AND`product.product_translation.parent`.product_version_id=`product.parent`.version_idWHERE (`product`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((((`product`.`id`=0x3C5E19CBE9C04CCCB22CB10CBAD16164OR`product`.`parent_id`=0x3C5E19CBE9C04CCCB22CB10CBAD16164)) OR ((`product`.`id`=0x84C4653946CE4FB5A040BFCB37BD42FFOR`product`.`parent_id`=0x84C4653946CE4FB5A040BFCB37BD42FF)) OR ((`product`.`id`=0x4EF05CE370934689A96085A5B2410924OR`product`.`parent_id`=0x4EF05CE370934689A96085A5B2410924)) OR ((`product`.`id`=0x67B88B8C5EEB47CEB5DBF4177C1CF029OR`product`.`parent_id`=0x67B88B8C5EEB47CEB5DBF4177C1CF029)) OR ((`product`.`id`=0x23169A7B67604A798AC2D3D2A347DD2FOR`product`.`parent_id`=0x23169A7B67604A798AC2D3D2A347DD2F)) OR ((`product`.`id`=0x25CD20387DA44903959B713FEA850759OR`product`.`parent_id`=0x25CD20387DA44903959B713FEA850759)) OR ((`product`.`id`=0x0F2E310F5A014DACAAE676CADF7122E5OR`product`.`parent_id`=0x0F2E310F5A014DACAAE676CADF7122E5)) OR ((`product`.`id`=0x2EAC8DC87F81471CA94B54AD61F86E89OR`product`.`parent_id`=0x2EAC8DC87F81471CA94B54AD61F86E89)) OR ((`product`.`id`=0x2B6B68EE3E9F4B5093EF7748D069EE84OR`product`.`parent_id`=0x2B6B68EE3E9F4B5093EF7748D069EE84)) OR ((`product`.`id`=0x3B4F0EAC635C44BB9AF885D155D00C94OR`product`.`parent_id`=0x3B4F0EAC635C44BB9AF885D155D00C94)) OR ((`product`.`id`=0xB460DA71668140D1A190B8B5AFF05D08OR`product`.`parent_id`=0xB460DA71668140D1A190B8B5AFF05D08)) OR ((`product`.`id`=0x13E88C68E518483395C4B62C2B32D19DOR`product`.`parent_id`=0x13E88C68E518483395C4B62C2B32D19D)) OR ((`product`.`id`=0x83326780CA9F4BACA829677823C051C7OR`product`.`parent_id`=0x83326780CA9F4BACA829677823C051C7)) OR ((`product`.`id`=0xC0B0C81E2B5F4EF7BBB29957378DEACFOR`product`.`parent_id`=0xC0B0C81E2B5F4EF7BBB29957378DEACF)) OR ((`product`.`id`=0x33B9D02F84EF49618002D8EE7BA43820OR`product`.`parent_id`=0x33B9D02F84EF49618002D8EE7BA43820)) OR ((`product`.`id`=0x9A3C369584D44B17A1853EC8BFB61877OR`product`.`parent_id`=0x9A3C369584D44B17A1853EC8BFB61877)) OR ((`product`.`id`=0x7F1FA708D14B461F9BE08BDE2B791A09OR`product`.`parent_id`=0x7F1FA708D14B461F9BE08BDE2B791A09)) OR ((`product`.`id`=0x14D993643DB94CC291C727A590C0819BOR`product`.`parent_id`=0x14D993643DB94CC291C727A590C0819B))) ANDNOT (`product`.`display_group`<=>NULL) AND ((`product.visibilities`.`visibility`>=10) AND`product.visibilities`.`sales_channel_id`=0x6C889B917EF14E05BB6083F2C55190C5ANDIFNULL(`product`.`active`,`product.parent`.`active`) =1))) GROUP BY`product`.`display_group`ORDER BYMAX(COALESCE(`product.translation.name`,`product.parent.translation.name`)) DESCLIMIT50;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`IN (0x0F2E310F5A014DACAAE676CADF7122E5,0x13E88C68E518483395C4B62C2B32D19D,0x14D993643DB94CC291C727A590C0819B,0x23169A7B67604A798AC2D3D2A347DD2F,0x25CD20387DA44903959B713FEA850759,0x2B6B68EE3E9F4B5093EF7748D069EE84,0x2EAC8DC87F81471CA94B54AD61F86E89,0x33B9D02F84EF49618002D8EE7BA43820,0x3B4F0EAC635C44BB9AF885D155D00C94,0x3C5E19CBE9C04CCCB22CB10CBAD16164,0x4EF05CE370934689A96085A5B2410924,0x67B88B8C5EEB47CEB5DBF4177C1CF029,0x7F1FA708D14B461F9BE08BDE2B791A09,0x83326780CA9F4BACA829677823C051C7,0x84C4653946CE4FB5A040BFCB37BD42FF,0x9A3C369584D44B17A1853EC8BFB61877,0xB460DA71668140D1A190B8B5AFF05D08,0xC0B0C81E2B5F4EF7BBB29957378DEACF)));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x0F2E310F5A014DACAAE676CADF7122E5AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x9BD8FF1B879948BB83630CAED01FBCD5));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xC0B0C81E2B5F4EF7BBB29957378DEACFAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x1C1DC9A2B78740509E1558F6363B82DE));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x33B9D02F84EF49618002D8EE7BA43820AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x72E5AB5E314B4D0BB13EFDF3A3977C5B));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x3C5E19CBE9C04CCCB22CB10CBAD16164AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xD34241297B1346CB82EFE9E11479B66F));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x2B6B68EE3E9F4B5093EF7748D069EE84AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x6688DD206D2A4F5CB9016689ABE0E648));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x3B4F0EAC635C44BB9AF885D155D00C94AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x3BB2C84ED6944ADF910795196355A06D));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xB460DA71668140D1A190B8B5AFF05D08AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x107AA1ED990C405DA6810DA63FB0891C));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x13E88C68E518483395C4B62C2B32D19DAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x233B5992A6C64550A5DD9E722F573279));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x83326780CA9F4BACA829677823C051C7AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xC4FF95C30A66435F8752886A939170D8));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x23169A7B67604A798AC2D3D2A347DD2FAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x22A8E057AD9E4C7C92F33FB153E4B141));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x25CD20387DA44903959B713FEA850759AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x3EEFBD959165478293E1D8AED5336233));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x84C4653946CE4FB5A040BFCB37BD42FFAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xD53C14789E774199B710B9500E98D55F));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x4EF05CE370934689A96085A5B2410924AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xFF6A9CD36CE24769B8904279BD5A7819));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x67B88B8C5EEB47CEB5DBF4177C1CF029AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xC13D7B01EEFE47A88667109F24D65464));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x2EAC8DC87F81471CA94B54AD61F86E89AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x3297C5AD2A3745A6B6F96CEB19D1B143));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x9A3C369584D44B17A1853EC8BFB61877AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xD267E13EA34741C4B21377F988E51366));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x7F1FA708D14B461F9BE08BDE2B791A09AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x7F584F3992314818A11F11A996F05643));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x14D993643DB94CC291C727A590C0819BAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x234448EDE6C249D0B3FD29863F2C5E22));
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`IN (?,?,?,?,?,?,?,?,?,?)))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`IN (?,?,?,?,?,?,?,?,?,?)
)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`IN (0x0F807F52A3F34DED9116DBAEE5F93B8D,0x2ED1932B46C440A19803CE85859DA922,0x391FC43A7E5448BDB021EBEB7B1C20D5,0x3EFFB08F60EF40E693E2F3BE48B18B6E,0x587FD9D520B44C8FBF017A87DDB8022B,0x7AFD0B8D9279475AAF34B0CF59AE878D,0x8FB7FB13F0C04F96B5BAADD326B7F806,0xD8421412C15641DBBFDC1E9719C1B81E,0xDE70903FE7714630A98AA35D0C9FF4B7,0xEC65FBA359604A5C98504BADA6E25343)));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x8FB7FB13F0C04F96B5BAADD326B7F806AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x7D08F22A14A24060933E166A41143D27));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xDE70903FE7714630A98AA35D0C9FF4B7AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xCAF495697C6F426685680AA2766A3359));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x587FD9D520B44C8FBF017A87DDB8022BAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xF9878531B2AB415EB18920FDA02E5A62));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xEC65FBA359604A5C98504BADA6E25343AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xB03BCE96E75D457396C255B1DCC840D7));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x391FC43A7E5448BDB021EBEB7B1C20D5AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xCAD25EB36CEA47ACBD0FBBDCDC6F8DB8));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x2ED1932B46C440A19803CE85859DA922AND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xAE6E622E31E34C2A8CA41854BF97E88D));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x0F807F52A3F34DED9116DBAEE5F93B8DAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xB503DE674B3E49ECA7F41B6EEEB108C3));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x3EFFB08F60EF40E693E2F3BE48B18B6EAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xF51A5CF4A27849899B17F6025DDAA6A7));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0xD8421412C15641DBBFDC1E9719C1B81EAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0x28BEDD66CACB46AA8965F588706FBF1D));
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND ((`product_price`.`product_id`=?AND`product_price`.`rule_id`=?)) LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
(
`product_price`.`product_id`=?AND`product_price`.`rule_id`=?
)
)
LIMIT1
SELECT`product_price`.`id`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id`=0x7AFD0B8D9279475AAF34B0CF59AE878DAND`product_price`.`rule_id`=0x51807DC8D2EC4868915E2B1C2B9E39EA)) LIMIT1;
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=?) AND (`product_price`.`id`IN (?))
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE
(`product_price`.`version_id`=?)
AND (
`product_price`.`id`IN (?)
)
SELECT`product_price`.`id`as`product_price.id`,`product_price`.`version_id`as`product_price.versionId`,`product_price`.`product_id`as`product_price.productId`,`product_price`.`product_version_id`as`product_price.productVersionId`,`product_price`.`rule_id`as`product_price.ruleId`,`product_price`.`price`as`product_price.price`,`product_price`.`quantity_start`as`product_price.quantityStart`,`product_price`.`quantity_end`as`product_price.quantityEnd`,`product_price`.`custom_fields`as`product_price.customFields`,`product_price`.`created_at`as`product_price.createdAt`,`product_price`.`updated_at`as`product_price.updatedAt`FROM`product_price`WHERE (`product_price`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_price`.`id`IN (0xB105A30C101E4CC1B88CACEFADA2565C));
# cms::moorl-brand-slider-v2::search-idsSELECT`product_manufacturer`.`id`FROM`product_manufacturer`WHERE (`product_manufacturer`.`version_id`=?) AND ((NOT (`product_manufacturer`.`id`<=>?))) AND (`product_manufacturer`.`id`IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) LIMIT9999
# cms::moorl-brand-slider-v2::search-idsSELECT`product_manufacturer`.`id`FROM`product_manufacturer`WHERE
(
`product_manufacturer`.`version_id`=?
)
AND (
(
NOT (
`product_manufacturer`.`id`<=>?
)
)
)
AND (
`product_manufacturer`.`id`IN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
LIMIT9999
# cms::moorl-brand-slider-v2::search-idsSELECT`product_manufacturer`.`id`FROM`product_manufacturer`WHERE (`product_manufacturer`.`version_id`=0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((NOT (`product_manufacturer`.`id`<=>0x653BB020FE1548028338676C4161F550))) AND (`product_manufacturer`.`id`IN (0xBDE6D141B76A41C4A4BECB1CD21A0690,0x496D58DEE699443F99D66A229214D30D,0x1C4579BC00D049DF8B08669CDD76F011,0x52228F3EDB1A4B938098D6A9B6A4AB84,0x4D9E45EB98B04A81B5C3E125386EE609,0x490DE072CA4E434D86BEA56303721054,0xFB389EB7D68C4F858976FABAFFF440CA,0xBA0E574A5D3F49F892B1C9357FE13C4F,0x738773D909604C588FFF30A7BF12494A,0x95EE6A1C717D49D5943F3BBF6E0D671F,0x904A39C22A1C4A6598AA6C36D75DAA4B,0x6D037E971F7F40C4B50C328109B6AD24,0xCEC88BB673754A9581BB233E47BD3ED9,0x82EC0968D51E41CAACDBCD226E1974E6,0xABB4C510AB534B0189A4ED1D928E7C27,0x22118F13D30641D99A144E3D3D3DCEBB,0xAF1B426FC97E47DD8268A5BCE6043786,0x9DE4AA8524A64BCF822B2D891EBD2768,0x167175283D42465E80723D751B916A50,0x255DDD2B5A3C467890387C4BA8921524,0x31E3D32E14E349E1A0494DEE2125AEC4,0x03FF53EE926844C7B4C21FEE91ADE5E8,0x5E42CC0F5FC54F86939C0ACE82A859A0,0x23288FD0CDE443BA9CEFD79D597468AE,0x9974C8B0967B46888606CE6424BAA3CF)) LIMIT9999;
SELECTconfiguration_key,configuration_valueFROMsystem_configWHERE (sales_channel_idISNULLORsales_channel_id=?) AND (configuration_keyLIKE?) ORDER BYsales_channel_idASC
SELECTconfiguration_key,configuration_valueFROMsystem_configWHERE
(
sales_channel_idISNULLORsales_channel_id=?
)
AND (configuration_keyLIKE?)
ORDER BYsales_channel_idASC
SELECTconfiguration_key,configuration_valueFROMsystem_configWHERE (sales_channel_idISNULLORsales_channel_id=0x6C889B917EF14E05BB6083F2C55190C5) AND (configuration_keyLIKE'FlixxSharingBarSW6.config.%') ORDER BYsales_channel_idASC;
SELECTseo_path_info,path_infoFROMseo_urlWHERE (seo_url.is_canonical=1) AND (seo_url.path_infoIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (seo_url.language_id=?) AND (seo_url.sales_channel_id=?ORseo_url.sales_channel_idISNULL) AND (is_deleted=0) ORDER BYseo_url.sales_channel_idASC
SELECTseo_path_info,path_infoFROMseo_urlWHERE
(seo_url.is_canonical=1)
AND (
seo_url.path_infoIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
AND (seo_url.language_id=?)
AND (
seo_url.sales_channel_id=?ORseo_url.sales_channel_idISNULL
)
AND (is_deleted=0)
ORDER BYseo_url.sales_channel_idASC
SELECTseo_path_info,path_infoFROMseo_urlWHERE (seo_url.is_canonical=1) AND (seo_url.path_infoIN ('/','/navigation/498b192b20aa4b5085f2e95ae247fb49','/navigation/225346ae25f24affb25f0d37b84d1966','/navigation/7c4885c9687c4398a9a2aee1aef1264b','/navigation/5bbe16c618054f8ab206d580f352faef','/navigation/c6140ccdb06340908743eabac9db86ed','/navigation/018a8d0b3660497eb5477853d3bbdc70','/navigation/ca5b6d41c85e4db698c0322eabe2ae08','/navigation/aa6725a2c924419a8d74a17242e99405','/navigation/f2d139aed2244b82bc368fc888eafdf6','/navigation/fcdc25a91a654edf83e9a4f2ea4986a0','/navigation/3b4827bc674440ec90db80c1941d2ead','/navigation/7574e77ca92645c590b1610a181cde41','/navigation/4cf979534f9b49c084906b3be004271d','/navigation/7f4ac2ece2cd4ab79ec26870d93f3205','/navigation/875cece42d6b47a49301ec375570ca7d','/navigation/aff650f24200437299cf80901435b5bf','/navigation/643be639c71d4e5285a17fd5a59937df','/navigation/700bb958f8164d81bfbc6e5c507578b8','/navigation/af1f6bc1439146728779719b4558385c','/navigation/b130a422db6f49ce83efd60e7046188d','/navigation/a75af42b17e0435b80e1f7b6ffc2e0ef','/navigation/fb93318d399644aabf2b0ad149216a47','/navigation/9404500f462949b1889dc66dd5fbed17','/navigation/e16212eca8674c4f896adfddc0c8bf08','/navigation/02edf64bdc1342baaf997800a94d796a','/navigation/096b4f5906c6457b9f46a6de460a40dd','/navigation/dfe2121cd65348bebf8344c1b5236dab','/navigation/c63cf4454aa34ba1916f63c5723a9c25','/navigation/5e7219135f204451ae2fe1887ca446e1','/navigation/1c3f9bc56aff4623b72075e5e7118ef2','/navigation/01f8c4f41b4a4e4c8c83e39cb72b2434','/navigation/54041b5aa0c14e18b7149cc88b4127ce','/navigation/f9774670bb8f4678bc1bd5a42ce4f78a','/navigation/c5e11875faf941c493b8df27a7f01220','/navigation/45f676935a174c49adf46256c5e2bc46','/navigation/dd4015c0850e43eaa052bebdbb88d379','/navigation/c0688a1199e849449541d15ba3f536f0','/navigation/cc1b5ae22bad474cbb3dfec99938704f','/navigation/b5dd474056564f2d8f123d9d69bf7ca4','/navigation/a01e198aedc849b18bd1e26a0bdc1917','/navigation/9bdb084e02014fb2b169c96876676ad7','/navigation/eafc3be269b9471484514713c729ab26','/navigation/2e771595c7f94dc8bf55bae768c0cd4c','/navigation/a1078f3180fe44b4802d09abd6de1ca3','/navigation/b5ce1b4fc27c41b8815800ab728185c6','/navigation/62de58c549ec4d888843c8d1e76e51ab','/navigation/2f6ac1dfe8ae4cb5a9eb6559d9cbd7e7','/navigation/ff3ce11dc9974193a24f13778f6c4b6d','/navigation/1c84150814234669958943c700dc1366','/navigation/e9bb620a04254d64bcc7ead50aac11a4','/navigation/89a60f8e44e3424892a53e44ae6542ad','/navigation/baab2792ea82445fbfe2abcd54da4a17','/navigation/f768288d47274654a65a930f8b2c85da','/navigation/3ef86492fd8d44f4bd689d67963759e5','/navigation/7fae191313c44ab09ffd5989c4348489','/navigation/8f39227d6dab4780ba0d9766e5b63e55','/navigation/0b906de5a6dd4169babcdffef1e34100','/navigation/9ac4108f281543d2a2cce0c677829681','/navigation/f5561d8316d9438fbeb5a9c28292eeeb','/navigation/ae5e1520c5c74a80b1221e5515c36bca','/navigation/e0c70c1711514eb6a9f273779da6fa33','/navigation/5c39e4331c284cc9b252cf390520c4ea','/navigation/d7167a40e16f475bb264fb1b58c57fd8','/navigation/be7acbf291b044628ea95c65f4d8c0a5','/detail/7f1fa708d14b461f9be08bde2b791a09','/detail/efee33909f444317ad5f3e0d1476b7ab','/detail/57ef33a14e6b46b7adf9ef913913075b','/detail/83326780ca9f4baca829677823c051c7','/detail/13e88c68e518483395c4b62c2b32d19d','/detail/2ef935ee014248f486cb26a9c3c6eacf','/detail/14d993643db94cc291c727a590c0819b','/detail/b460da71668140d1a190b8b5aff05d08','/detail/3effb08f60ef40e693e2f3be48b18b6e','/detail/b9a372ab3031490cb23b527336f2ae64','/detail/0f2e310f5a014dacaae676cadf7122e5','/detail/c0b0c81e2b5f4ef7bbb29957378deacf','/detail/33b9d02f84ef49618002d8ee7ba43820','/detail/3c5e19cbe9c04cccb22cb10cbad16164','/detail/2b6b68ee3e9f4b5093ef7748d069ee84','/detail/3b4f0eac635c44bb9af885d155d00c94','/detail/23169a7b67604a798ac2d3d2a347dd2f','/detail/25cd20387da44903959b713fea850759','/detail/84c4653946ce4fb5a040bfcb37bd42ff','/detail/4ef05ce370934689a96085a5b2410924','/detail/67b88b8c5eeb47ceb5dbf4177c1cf029','/detail/2eac8dc87f81471ca94b54ad61f86e89','/detail/9a3c369584d44b17a1853ec8bfb61877','/detail/8fb7fb13f0c04f96b5baadd326b7f806','/detail/de70903fe7714630a98aa35d0c9ff4b7','/detail/587fd9d520b44c8fbf017a87ddb8022b','/detail/ec65fba359604a5c98504bada6e25343','/detail/391fc43a7e5448bdb021ebeb7b1c20d5','/detail/2ed1932b46c440a19803ce85859da922','/detail/0f807f52a3f34ded9116dbaee5f93b8d','/detail/d8421412c15641dbbfdc1e9719c1b81e','/detail/7afd0b8d9279475aaf34b0cf59ae878d','/navigation/b869b50db7d54f32b3f1c0dcbc76cb05')) AND (seo_url.language_id=0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id=0x6C889B917EF14E05BB6083F2C55190C5ORseo_url.sales_channel_idISNULL) AND (is_deleted=0) ORDER BYseo_url.sales_channel_idASC;