POST https://sw65.test.firebearstudio.com/api/search/product?q=%2Fapi%2Fsearch%2Fproduct

Response
200 OK
IP
10.244.1.214
Profiled on
Token
dcd598

Query Metrics

25 Database Queries
20 Different statements
62.38 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
7.84 ms
(12.57%) 		6 
SET @n = 0; SET @c = null;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.14 ms
(11.45%) 		1 
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `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_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ÿcüª«pHª´R)\x0Eób1k"
  b"þ ™ìöÙK3‘Åë•-Ž¾À"
  b"ýEÂP¨(A\x04¬žþúÁÈb\"
  b"""
    úJ\x10¶ï\x12AÚœÍ\n
    ´Õ8Л
    """
  b"ù–\fÏ\x17\x03O*•œZò«ò=ó"
  b"÷ã’[û°DÚ¡\x08Žé\x18+Ú\x13"
  b"÷Ï\rú&ºAö¨_$Œx\x1EcÔ"
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  b"ós/îÆjLý¡\eì\x12’ºÍu"
  b"ò%´\f0ïK“˜šÖ#dgËû"
  b"ñØ*\x1C¬‘DTœv®ôº­›$"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"éa\fª\OHQ’ÇmƳ¬¹±"
  b"éM¯‘Í\x14J·¿Ù/ÿâq\x7F""
  b"æò‡#Ô›M`†¿ÂyA\x14µž"
  b"åÕ*yMWLwž-î™ÁŸìë"
  b"Õ=\█êêA`ü\x08/b¨lG┼"
  b"õÛ\x17Ť╩G┼í»ØêY╦I["
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"âWXË\x1FÉE=¶Ç÷Uâ+\rv"
  b"ß-§#’!B\x06©1Ô\x1Fb\x07Á\x01"
  b"Þ›Éî@°O—«\vQ[ü\x0FÜS"
  b"▄*iØeEL\x11ø═«ÜYçÕY"
  b"ÙÕ\x02£ê5Oô íÃHš\x17I"
  b"""
    ÏÙå6}SL\x19¥QöØÔ▀\n
    l
    """
  b"×GÑ\x1A÷QM\x7F…71\x1A.]•«"
  b"ÔçBx'<BöŠ½8b\x1Dê\x121"
  b"Ó™ÕùéGͽD\x0Eö‡ØwÓ"
  b"Òõ܈ÆdNû”Á¨‚C\x05W\x12"
  b"ÒÚþhU»G¹ŽQšMÔo\x00S"
  b"Ð7Ø¥,└F╚ÑÑ0Ò²ÞÖ~"
  b"""
    І=\n
    ã”B{Œ0i¤uàKÎ
    """
  b"ϛnj{zO¶•\x06¡êc…°S"
  b"Ì!®³75B3«®¢c\x17c\x07â"
  b"""
    É·Ë5i–AfœÈ \n
    ·0\x17“
    """
  b"É¢[QŽ4@G ?çþ8\x0FŒ\x12"
  b"""
    È¡ÚgŠ=JV¤á¯û\n
    ÖìL
    """
  b"Ƭk6¡\x12@>»£p\f_;\x02É"
  b"Å=¿‘@xJ‹¯‡ÜúŠô\x15"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"Áh\t'”îK.˜4t“\t\x13S\x1A"
  b"À\x06äþ‘mMà…Øç§ú_öÇ"
  b"¾5…I±\e@âŒlwp4€O’"
  b"""
    ¼ÛäC2åIY¿*ýl\n
    4À0
    """
  b"»èˆÉ6ñG\x03¹¤tˆlåˆ("
  b"»ŸIé\x184O…Ž"\x1E¥\x1E»\x10©"
  b"╗ZeqiEJ\x1E©Ï╩É\x08ÄÕj"
  b"©É¨Ä╣E@Jà\x1DI\x10\x0F%m╗"
  b"¸V&rš¨Mǵ\x7F<”¿,ˆ9"
  b"·\fw\x1E\x1CûH\x11³Ž):\x12’q]"
  b"´\x17÷Õ\x17MFߣ\x14O±åwµ4"
  b"±U\x05Sð\x19K=€è¬ÛÅò[Þ"
  b"¡ÉäøWÄMàÅéXå\x009f?"
  b"¼ìÌ;øÂKÔêA╬õ(╝═g"
  b"¬A"ïë\x19K·„\x1AŠPJ\x05\fw"
  b"ª¬J•zÌNÔ°¨Á‘gXBï"
  b"©v@8Ý8F}¶ò¼dÜû<¡"
  b"¦P¿Ó|¢JlˆÝ!1NîÛû"
  b"¤±—\x1CdVJ,ˆ\x04ØwêðP×"
  b"ƒ²<\x1FØ▄J}é\x128â@º)U"
  b"Ÿ²!M!®L)„ÿÍ·§ªl."
  b"ØcU»\e2FõøE×ýYl░b"
  b"›ö‰u1\x05@4½ Çtå`6x"
  b"˜ðT[\x0FíLJ€K‹p½Èˆg"
  b"ÿؽ\x19\x08ïH▄ƒ\Ã¥╗ C["
  b"—²Y*À\x1AKßšJ2ë'½l\x16"
  b"•†rªþ`GJ®ä\x16p\x0ER/È"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"“œÌ!ÿWAÁŒéâ%æG›\x13"
  b"’å*w\x1DôLˆ¦,<F¡sDï"
  b"Ž\x14á¶kàOJ±P¹d‚òÏ""
  b"ŒÓƒ•þýBùŽüפÒ\x15Ÿu"
  b"îa\x00,¸gB²êT\x05÷ŶëY"
  b"""
    ‹øèžÚ#H\r²K\n
    \x1E9DûÔ
    """
  b"è/ÆÅI+N²ƒ\fÕ\x04\x12@ó"
  b"ˆnåÎŽæC\tƒ£µÒ3S\\x14"
  b"å▄1Øi═L\x14ù╔®]█▓Ö\t"
  b"…o{µÕÔC°¥Ln">0€„"
  b"ƒóè´nECÉ’G\x11!°ÇÁ¸"
  b"‚kbúé\x16JÊ‚.~r•K8`"
  b"€æ\x08BÜ\x04K\x08®#Ž[h\x11¿."
  b"}¾o\x1F\x1A’F°¨Y§fåý‹i"
  b"yç?¿Ó’F\v»€·¤·¦³Ï"
  b"xtŃ³êBrŸ;éTG\x06ìe"
  b"wÒ\x1AB¨gN”²€õ©Ø±×E"
  b"wÊ4<\flA@ŽõŽ|­-P²"
  b"u¦ykr$@y„†-\x04Ø\x15\x7F%"
  b"q¤Sìl\x16Eë–Rè\x15Ê~–ø"
  b"pnîf~'Oˆƒ4ŸÆýye:"
  b"p\‘rØ[Iì‚ø ë \fê;"
  b"oíõO3TD\x1E²®\x16!\x7FáU‚"
  b"nJÞ¢P˜G\´\x17\x04¦_VH$"
  b"mÂ!뤭FÉ¿─\x16QQ\x07v\x1E"
  b"l=\x07\tÓoL\x1AÅ@#┬±=╚Å"
  b"l9ì\x7Fû▓Bßé5é÷&ë¤d"
  b"k²Ò■\e╗A▒¬BqÅÿOën"
  b"k╠DMÑúB\x13í=╠W\x02¤Ø¸"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"gô$ŽB\x05E6¡\x06è#$ûª”"
  b"c╠╔┴ñáK²É\x1EÓ▒\x19ƒ▀9"
  b"_\x14\x16\x07\x00\x10C–™\x1AÑj6M8Â"
  b"^X¬0=ˆH–˜ž°\x10žö»y"
  b"]\x13?h\x16ÿ@Ó–F5FÝÌ·N"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"\&¸¡<¢G\x04┤Ù«ßÉ\ryh"
  b"Xì\x1FÇüâF{ˆ“¯ñ‰u\x17²"
  b"UµµÒ¶\x07F¿„ÕÛ&áïÖ."
  b"Uª\x7FcM²A%µhè\x19˜\x030Y"
  b"U¦¼±žëN\x15‰Ç:Sõ’´C"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"Tµ\rŒN\x18A¢Œe‘Dt#ç("
  b"QÅújì╚LØ┤á½ã>Þq▄"
  b"Q\x18;èïhFy¯J.o4‡hz"
  b"N\x7FTÕ"fI0€²ÿ¹l×Æë"
  b"J”´Z@îHK§C\x05‰@»§·"
  b"JV$wt¼N³•\vSp`y\;"
  b"HË·\x1CÈ│L[ƒü¡ç╬|íÆ"
  b"H^ÕVB└AâÅ°┘ñ┼«¤S"
  b"E¸Ö¾A\x17I«ì█Ì.é?╩┼"
  b"Dc˜õqçOh¬yˆ¬a´†Ì"
  b"D6\x1A╔Å,K\x01á\x03º\x08F═d^"
  b"D\x1Fü”ÞšD秀*P‹1ãÎ"
  b"C\x05–K›œN¹¦\x08­í\e#N®"
  b"@þø¦åŸJ‰¼a­›ëgõ\e"
  b">á\x10e*ºCò£\x04ø• av§"
  b">Á›¶±"H?«ya\x02\t 3À"
  b"> }hv½E–¥TÝòT†…c"
  b";\x1F¸¨`æLD½[É\ÿéÉ%"
  b":§\x10óZìOÿ£]{€–zDR"
  b"8\x1AKc║âN┴¼{ì×EáA\x06"
  b"7üºÎ|6BHí┬ùè\x1C‗ºÛ"
  b"5[ ŠˆhL¢ \x17\x16ÜÀ[§Æ"
  b"4DÃ┐\x08ü@íÀ³DÌ‗¿áY"
  b"2P\x7F"—èF\vŸÍ\x0E³Ù\x7F9©"
  b".\x1F\x07╦\x1AÕHì©\r)d\v\x04Ø\x19"
  b"-uÉ6íèM¤«Uz“Ÿö¶ä"
  b"+²\x07ǘîHH³2Ñ)Å#ªw"
  b"+T ÷Í;O÷žÊŸcœˆ…'"
  b"*ÿÓÄm#@Š‡\x7FC¢œvâB"
  b")\x01Ô9ÿJIé±\t·Ã\x04ÅI“"
  b"&K­M\fXK½©u6\x08ÇÙ’î"
  b"#+OÊ1.N(’ö¬{J.—ˆ"
  b" ­G?ù\x03C;–«¹\x1Ea{ö´"
  b"\x1EœÑÑ!úIT‚5Ø–\vÓ\¶"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\eÀv\x18ŒvN´©:álÀ\x142$"
  b"\x19Ú%\x’Lâºlè*g\x01·\x1C"
  b"\x19\x1FŠ‹¶\x0FJš³/gð×D]˜"
  b"\x14æb\x16D*I%•-º\x03„ÓŠ\"
  b"\x14´H\x19±‘L(³\x10…>\x02§åù"
  b"\x11\x15íƒ╚IBËÉ#╔U\x1C`7╩"
  b"\x0E쮘­¥I\x14¥5WI\x7F\x0F\x08\"
  b"\fÆš¤rbKÆ€"wáKÿŸ]"
  b"\v°Éµñ}@æªÒj\x15›²N\x1A"
  b"\x08/ÓP2ìD\x07º¥“QæÁ\x01á"
  b"\x07t0ìR2K÷›Ö\x1CÓ§ª{Ú"
  b"\x06íT“K~I³’çßœ]K•&"
  b"\x06O}╝\eeKìí0£■└>Ï¿"
  b"\x02\x15½€#–@3 Ž|þ\x19\x11jQ"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.12 ms
(8.20%) 		1 
SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product`.`parent_id`, @n+1, IF(@c:=`product`.`parent_id`,1,1)) as id_count, `product`.`parent_id`, `product`.id FROM `product` WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY `product`.`parent_id` ASC) child ON child.parent_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  1
  500
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.66 ms
(7.47%) 		1 
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = ?
Parameters: 
[
  "cache-id"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.32 ms
(6.92%) 		1 
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = ?) AND ((`product`.`product_number` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) LIMIT 25 OFFSET 150
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "Effect-S1"
  "EF0110-1313-03"
  "EF0110-1318-03"
  "EF0110-1520-03"
  "EF0110-1824-03"
  "EF0110-2020-03"
  "EF0110-2025-03"
  "EF0110-2028-03"
  "EF0110-2030-03"
  "EF0110-2130-03"
  "EF0110-2370-03"
  "EF0110-2430-03"
  "EF0110-2535-03"
  "EF0110-2550-03"
  "EF0110-2560-03"
  "EF0110-2570-03"
  "EF0110-2580-03"
  "EF0110-2835-03"
  "EF0110-3030-03"
  "EF0110-3040-03"
  "EF0110-3042-03"
  "EF0110-3045-03"
  "EF0110-F1-03"
  "EF0110-3550-03"
  "EF0110-4040-03"
  "EF0110-4050-03"
  "EF0110-4060-03"
  "EF0110-4260-03"
  "EF0110-5050-03"
  "EF0110-5060-03"
  "EF0110-5065-03"
  "EF0110-5070-03"
  "EF0110-5075-03"
  "EF0110-6060-03"
  "EF0110-6080-03"
  "EF0110-6084-03"
  "EF0111-1313-03"
  "EF0111-1318-03"
  "EF0111-1520-03"
  "EF0111-1824-03"
  "EF0111-2020-03"
  "EF0111-2025-03"
  "EF0111-2028-03"
  "EF0111-2030-03"
  "EF0111-2130-03"
  "EF0111-2370-03"
  "EF0111-2430-03"
  "EF0111-2535-03"
  "EF0111-2550-03"
  "EF0111-2560-03"
  "EF0111-2570-03"
  "EF0111-2580-03"
  "EF0111-2835-03"
  "EF0111-3030-03"
  "EF0111-3040-03"
  "EF0111-3042-03"
  "EF0111-3045-03"
  "EF0111-F1-03"
  "EF0111-3550-03"
  "EF0111-4040-03"
  "EF0111-4050-03"
  "EF0111-4060-03"
  "EF0111-4260-03"
  "EF0111-5050-03"
  "EF0111-5060-03"
  "EF0111-5065-03"
  "EF0111-5070-03"
  "EF0111-5075-03"
  "EF0111-6060-03"
  "EF0111-6080-03"
  "EF0111-6084-03"
  "EF0112-3510-03"
  "EF0112-5010-03"
  "EF0112-6090-03"
  "EF0112-F2-03"
  "EF0112-6293-03"
  "EF0112-7010-03"
  "EF0112-7070-03"
  "EF0112-8080-03"
  "EF0112-8010-03"
  "EF0112-8411-03"
  "EF0110-1313-01"
  "EF0110-1318-01"
  "EF0110-1520-01"
  "EF0110-1824-01"
  "EF0110-2020-01"
  "EF0110-2025-01"
  "EF0110-2028-01"
  "EF0110-2030-01"
  "EF0110-2130-01"
  "EF0110-2370-01"
  "EF0110-2430-01"
  "EF0110-2535-01"
  "EF0110-2550-01"
  "EF0110-2560-01"
  "EF0110-2570-01"
  "EF0110-2580-01"
  "EF0110-2835-01"
  "EF0110-3030-01"
  "EF0110-3040-01"
  "EF0110-3042-01"
  "EF0110-3045-01"
  "EF0110-F1-01"
  "EF0110-3550-01"
  "EF0110-4040-01"
  "EF0110-4050-01"
  "EF0110-4060-01"
  "EF0110-4260-01"
  "EF0110-5050-01"
  "EF0110-5060-01"
  "EF0110-5065-01"
  "EF0110-5070-01"
  "EF0110-5075-01"
  "EF0110-6060-01"
  "EF0110-6080-01"
  "EF0110-6084-01"
  "EF0111-1313-01"
  "EF0111-1318-01"
  "EF0111-1520-01"
  "EF0111-1824-01"
  "EF0111-2020-01"
  "EF0111-2025-01"
  "EF0111-2028-01"
  "EF0111-2030-01"
  "EF0111-2130-01"
  "EF0111-2370-01"
  "EF0111-2430-01"
  "EF0111-2535-01"
  "EF0111-2550-01"
  "EF0111-2560-01"
  "EF0111-2570-01"
  "EF0111-2580-01"
  "EF0111-2835-01"
  "EF0111-3030-01"
  "EF0111-3040-01"
  "EF0111-3042-01"
  "EF0111-3045-01"
  "EF0111-F1-01"
  "EF0111-3550-01"
  "EF0111-4040-01"
  "EF0111-4050-01"
  "EF0111-4060-01"
  "EF0111-4260-01"
  "EF0111-5050-01"
  "EF0111-5060-01"
  "EF0111-5065-01"
  "EF0111-5070-01"
  "EF0111-5075-01"
  "EF0111-6060-01"
  "EF0111-6080-01"
  "EF0111-6084-01"
  "EF0112-3510-01"
  "EF0112-5010-01"
  "EF0112-6090-01"
  "EF0112-F2-01"
  "EF0112-6293-01"
  "EF0112-7010-01"
  "EF0112-7070-01"
  "EF0112-8080-01"
  "EF0112-8010-01"
  "EF0112-8411-01"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.97 ms
(6.37%) 		1 
SELECT COUNT(*) FROM (SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = ?) AND ((`product`.`product_number` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))) total
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "Effect-S1"
  "EF0110-1313-03"
  "EF0110-1318-03"
  "EF0110-1520-03"
  "EF0110-1824-03"
  "EF0110-2020-03"
  "EF0110-2025-03"
  "EF0110-2028-03"
  "EF0110-2030-03"
  "EF0110-2130-03"
  "EF0110-2370-03"
  "EF0110-2430-03"
  "EF0110-2535-03"
  "EF0110-2550-03"
  "EF0110-2560-03"
  "EF0110-2570-03"
  "EF0110-2580-03"
  "EF0110-2835-03"
  "EF0110-3030-03"
  "EF0110-3040-03"
  "EF0110-3042-03"
  "EF0110-3045-03"
  "EF0110-F1-03"
  "EF0110-3550-03"
  "EF0110-4040-03"
  "EF0110-4050-03"
  "EF0110-4060-03"
  "EF0110-4260-03"
  "EF0110-5050-03"
  "EF0110-5060-03"
  "EF0110-5065-03"
  "EF0110-5070-03"
  "EF0110-5075-03"
  "EF0110-6060-03"
  "EF0110-6080-03"
  "EF0110-6084-03"
  "EF0111-1313-03"
  "EF0111-1318-03"
  "EF0111-1520-03"
  "EF0111-1824-03"
  "EF0111-2020-03"
  "EF0111-2025-03"
  "EF0111-2028-03"
  "EF0111-2030-03"
  "EF0111-2130-03"
  "EF0111-2370-03"
  "EF0111-2430-03"
  "EF0111-2535-03"
  "EF0111-2550-03"
  "EF0111-2560-03"
  "EF0111-2570-03"
  "EF0111-2580-03"
  "EF0111-2835-03"
  "EF0111-3030-03"
  "EF0111-3040-03"
  "EF0111-3042-03"
  "EF0111-3045-03"
  "EF0111-F1-03"
  "EF0111-3550-03"
  "EF0111-4040-03"
  "EF0111-4050-03"
  "EF0111-4060-03"
  "EF0111-4260-03"
  "EF0111-5050-03"
  "EF0111-5060-03"
  "EF0111-5065-03"
  "EF0111-5070-03"
  "EF0111-5075-03"
  "EF0111-6060-03"
  "EF0111-6080-03"
  "EF0111-6084-03"
  "EF0112-3510-03"
  "EF0112-5010-03"
  "EF0112-6090-03"
  "EF0112-F2-03"
  "EF0112-6293-03"
  "EF0112-7010-03"
  "EF0112-7070-03"
  "EF0112-8080-03"
  "EF0112-8010-03"
  "EF0112-8411-03"
  "EF0110-1313-01"
  "EF0110-1318-01"
  "EF0110-1520-01"
  "EF0110-1824-01"
  "EF0110-2020-01"
  "EF0110-2025-01"
  "EF0110-2028-01"
  "EF0110-2030-01"
  "EF0110-2130-01"
  "EF0110-2370-01"
  "EF0110-2430-01"
  "EF0110-2535-01"
  "EF0110-2550-01"
  "EF0110-2560-01"
  "EF0110-2570-01"
  "EF0110-2580-01"
  "EF0110-2835-01"
  "EF0110-3030-01"
  "EF0110-3040-01"
  "EF0110-3042-01"
  "EF0110-3045-01"
  "EF0110-F1-01"
  "EF0110-3550-01"
  "EF0110-4040-01"
  "EF0110-4050-01"
  "EF0110-4060-01"
  "EF0110-4260-01"
  "EF0110-5050-01"
  "EF0110-5060-01"
  "EF0110-5065-01"
  "EF0110-5070-01"
  "EF0110-5075-01"
  "EF0110-6060-01"
  "EF0110-6080-01"
  "EF0110-6084-01"
  "EF0111-1313-01"
  "EF0111-1318-01"
  "EF0111-1520-01"
  "EF0111-1824-01"
  "EF0111-2020-01"
  "EF0111-2025-01"
  "EF0111-2028-01"
  "EF0111-2030-01"
  "EF0111-2130-01"
  "EF0111-2370-01"
  "EF0111-2430-01"
  "EF0111-2535-01"
  "EF0111-2550-01"
  "EF0111-2560-01"
  "EF0111-2570-01"
  "EF0111-2580-01"
  "EF0111-2835-01"
  "EF0111-3030-01"
  "EF0111-3040-01"
  "EF0111-3042-01"
  "EF0111-3045-01"
  "EF0111-F1-01"
  "EF0111-3550-01"
  "EF0111-4040-01"
  "EF0111-4050-01"
  "EF0111-4060-01"
  "EF0111-4260-01"
  "EF0111-5050-01"
  "EF0111-5060-01"
  "EF0111-5065-01"
  "EF0111-5070-01"
  "EF0111-5075-01"
  "EF0111-6060-01"
  "EF0111-6080-01"
  "EF0111-6084-01"
  "EF0112-3510-01"
  "EF0112-5010-01"
  "EF0112-6090-01"
  "EF0112-F2-01"
  "EF0112-6293-01"
  "EF0112-7010-01"
  "EF0112-7070-01"
  "EF0112-8080-01"
  "EF0112-8010-01"
  "EF0112-8411-01"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.48 ms
(5.57%) 		1 
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `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_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.68 ms
(4.30%) 		1 
SELECT `product_configurator_setting`.`id` as `product_configurator_setting.id`, `product_configurator_setting`.`version_id` as `product_configurator_setting.versionId`, `product_configurator_setting`.`product_id` as `product_configurator_setting.productId`, `product_configurator_setting`.`product_version_id` as `product_configurator_setting.productVersionId`, `product_configurator_setting`.`media_id` as `product_configurator_setting.mediaId`, `product_configurator_setting`.`property_group_option_id` as `product_configurator_setting.optionId`, `product_configurator_setting`.`price` as `product_configurator_setting.price`, `product_configurator_setting`.`position` as `product_configurator_setting.position`, `product_configurator_setting`.`custom_fields` as `product_configurator_setting.customFields`, `product_configurator_setting`.`created_at` as `product_configurator_setting.createdAt`, `product_configurator_setting`.`updated_at` as `product_configurator_setting.updatedAt` FROM `product_configurator_setting` WHERE (`product_configurator_setting`.`version_id` = ?) AND (`product_configurator_setting`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    ú8\n
    —[GGˆµÜ€ñŠ\x1Cqœ
    """
  b"ø{±ÍI[JwŒÎä„t1”½"
  b"òs¶Ê$;O¨¯‘\x1Cõ¦c\x7F‡"
  b"±ª³³üÒJîÁ¯¢z]¯¾G"
  b"­ì\x15█HéB║¿█»■CI└\x1D"
  b"í-—\x13\x1CäLÔ»Èߤ³Wp\f"
  b"ëÕ”*C\tK\x05 öA¡ßfu‚"
  b"ê\x07\x1AÈ{9J¯•'Ú\x0Eë>bh"
  b"æßuîCŒF*Šü¶dý9$Œ"
  b"Ô¾Ò\x17Ú\x17BKÅèöBy│nq"
  b"ÔÉ│»:'H╩£1─ù‗]QÒ"
  b"áÐ[Ë-ÇK¨… 1B›5¬&"
  b"à¸å|\x13\tNË‘¯Ï°M·\x01T"
  b"ÞÏÄ.‰*N†‹a|ÔúÍU1"
  b"Û¶ÓO=ÿC¿™ \x1E~ßÓ\x1E/"
  b"ÚÖ\x1Dɳ_M\x1E¦PÙüú¸=ù"
  b"ØÂ…I\x1E\v@V¿\x0F·=\r½Žh"
  b"× y8\f¼Lg°ÖJhX.)°"
  b"×*¿ì¶™HܨÊÆ\x15itŸH"
  b"ջתÌ7H¨—Pnï+¯tÚ"
  b"Õ˜Ñ\x0FZJN=žŠŒ¯m°¸½"
  b"Õ\t\ex„^G5±×ßM*YÉ”"
  b"ÊY\x06Óô7N=¸±\x02Ï´N°\"
  b"É#\x04ës:OŽ¤kœZ^Ö…T"
  b"ï\x08©züGZÑÑà2fû\x11T"
  b"Áó\x0Eo]^D?¡åbf\x18ëpe"
  b"¥÷└bÅôN®¡a\x12\x1F \x02kJ"
  b"¸G€ô×´Cc°Õ\x1D,iÚRº"
  b"¶Ç¥ÙÔ¹IK¶\f‡#¾qƒT"
  b"¯\x02h\x04Þ\fLa¨7\e*Vká¸"
  b"¡¢FVù³A╔éØ\x1A§É╚q²"
  b"­i<Ú&\rF>Ÿ‚Þåè¦\x02¥"
  b"­\x19è\x0FQºBW”°%0¿/Å1"
  b"ó\x14)@NƒMSÅ´aMbÜ╝O"
  b"Ø%┬\x03ú\x1DK·æ\v.yyþ\fö"
  b"•fT›{ÊLY‘\x08˜Ñ÷°\x12g"
  b"”"„—L»Bɵ]º¨*’\x19õ"
  b"É|XìêÆHGô>,0ÈÏÅ9"
  b"åÞ\x114idO■íÇ╣Ø╚5]å"
  b"†—š~VŽA—¶5¡×ªAd?"
  b"…Q\x1F‰­vN¤ƒ™žõbØ\x13K"
  b"\x7FâwñnžC7¾\eK©³Kª2"
  b"~§Ú–Y\x7FE®€;\x03ÀnXù9"
  b"|î$«Ñ@NG¡žÆ}\x14»¾\f"
  b"{ðL'ë\x0FHòŒUôHˆ\x1Cùx"
  b"x\x01ã±|ìC1»ð*ú\x1A-Öp"
  b"sLY\x0E4┬Aüä0*¾Ñ°\v¡"
  b"r[B0D_@߈¨\x07\x06¼ø\x0EÇ"
  b"q©—ÚÜ|Iñ‰P.Di©? "
  b"q4D‘{åAϱ\x1Cw¥ù0Ê‚"
  b"nv\x07\x7FÚ·Eì¥\tHûzUt│"
  b"l¢(šl¶C…ŸŒÄÇ\e(Þ3"
  b"k*\x15ðh¶E\x10‘„¢V¡“,á"
  b"gšç>#[Dž¡¸\x03-θoi"
  b"e|9†OrIþ”\x03¼±\x17ÆfØ"
  b"b║A<ƒìNNîg$½foA┐"
  b"a=§\rñgE]±…ƒÎÉ. Ý"
  b"]>\rDE7D╔ÉÓ+õ┤³%&"
  b"X|‘§oÇAn¡\ßY—7m!"
  b"Xe"øã\x7FJ²š¼\x1E¬LX®è"
  b"X8EÞ\x7F\x1AJù¶BC,ð1&÷"
  b"W \tx«|I«£0\e\tUø!´"
  b"""
    SŠ\x08ŽL`G\n
    ˆ©‡‹\x11S+“
    """
  b"RPŽbÌ\x7FB\x0EµÐb^æ Ät"
  b"Oqî<³ÎNœ‡mCfeI{s"
  b"Nxð╝º÷H\tØØèûªì¹¾"
  b"N^Åþ]cIïâwL\x14nèÀ\x1E"
  b"MœÑøâ½C\x1Dƒ8\x13€=L½ˆ"
  b"""
    D¯N#~XA~‘\x05Õ»\x1F\n
     q
    """
  b"?\e¨È(>G“†žõ{ÿ\x0F\x12""
  b">DFÓ6dO¸±\x1Aç•ù3Íá"
  b":P¡;'OJ┐¿ÈJ§?Øy;"
  b"9È\x10ÊíÀH€ª¶´o2¤Cå"
  b"8Ù;\x1F│¨F?ª╠Å─O'1\x02"
  b"8äØ3´\eCìäÒÛ\x03yÎ┐ì"
  b"8L…Ö‘,Jέ‡÷9öweh"
  b"7█┤\x08m\x7FH¼ÉS░ ~╔;\x05"
  b"2á\tt4÷B&½ípåý§äO"
  b"0457ÅùO^à1§¥\x00vàÒ"
  b"*‚\x08ÿ+¥A"œKÈ\x19#\x02úî"
  b"(ÁÁ'ÓOG›ž·è­å)_\x0E"
  b"&\x18\füß©KD¤B!·^»Ü3"
  b"$a×æÅþCBê╗@\x1DWÎ═õ"
  b"!Ö\x0E}ı_Fpà úò)ÅÈ\x10"
  b" X_DíâH\x03“íaeO¡[©"
  b" \x1C™ž¦}F\x07§ÃŸ\x17\x12¿€æ"
  b"""
     \n
    “ßíØN¶ õ´\tKî.‚
    """
  b"\x1F'_H&§Lû«u†n¨iøö"
  b"\x1D÷˜óª¹Mǹt>H\x15\e¥z"
  b"\x1D×\x07@È^@¼É*¦®╝fC²"
  b"\x1A°ùÄ{@B6—ÓXžGQ¿\x1C"
  b"\x17 ùÆ…‹FÅ 1V4ü?¨Ÿ"
  b"\x16_0ö¥UK^É\x04îà\x7Fë▀¬"
  b"\x12q\x0E■qüOOªV¹\x16=ui┌"
  b"\fZ¿\x05ãðE\x07¥GríKb»\x0F"
  b"\f3õ\x1D+#H5¦i–äÂ\x7FâL"
  b"\v\x1A╚U*ìNTóÚ\x15Ú±ÿÙ¬"
  b"\x08mÄ@*ôC\Ø×K 6¡´X"
  b"\x05NñÒx\x0EO/œŒ\x04\tç\x1D½G"
  b"\x02°ü†K4EG«evªêìM+"
  b"\x01É<│úüAÈÀ\f\x08üá\x17ï╗"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.60 ms
(4.16%) 		1 
SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_media`.`product_id`, @n+1, IF(@c:=`product_media`.`product_id`,1,1)) as id_count, `product_media`.`product_id`, `product_media`.id FROM `product_media` WHERE (`product_media`.`version_id` = ?) AND ((`product_media`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY `product_media`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  1
  500
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.44 ms
(3.91%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.29 ms
(3.66%) 		1 
SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_visibility`.`product_id`, @n+1, IF(@c:=`product_visibility`.`product_id`,1,1)) as id_count, `product_visibility`.`product_id`, `product_visibility`.id FROM `product_visibility` WHERE (`product_visibility`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `product_visibility`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  1
  500
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.25 ms
(3.61%) 		1 
SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_configurator_setting`.`product_id`, @n+1, IF(@c:=`product_configurator_setting`.`product_id`,1,1)) as id_count, `product_configurator_setting`.`product_id`, `product_configurator_setting`.id FROM `product_configurator_setting` WHERE (`product_configurator_setting`.`version_id` = ?) AND ((`product_configurator_setting`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY `product_configurator_setting`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  1
  500
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.04 ms
(3.27%) 		1 
SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`seo_url`.`foreign_key`, @n+1, IF(@c:=`seo_url`.`foreign_key`,1,1)) as id_count, `seo_url`.`foreign_key`, `seo_url`.id FROM `seo_url` WHERE (`seo_url`.`foreign_key` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `seo_url`.`foreign_key` ASC) child ON child.foreign_key = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  1
  500
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.95 ms
(3.13%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.88 ms
(3.01%) 		1 
SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = ?
Parameters: 
[
  b"àu[L╠«H=╗¯N]ü╦\e\x07"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.85 ms
(2.97%) 		1 
SELECT id FROM integration WHERE access_key = ?
Parameters: 
[
  "SWIAMZNMOXDXTKXOB1FOAGJRZG"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.75 ms
(2.80%) 		1 
SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_price`.`product_id`, @n+1, IF(@c:=`product_price`.`product_id`,1,1)) as id_count, `product_price`.`product_id`, `product_price`.id FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY `product_price`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
  1
  500
  b"\x1Eüv\x11¹£JÝ¿i\x15╚\x01#w»"
  b"\x1E†JÊ=·J×€^2ªŸR}Œ"
  b"U—`\x16u7Eî²G–90^Ðd"
  b"\┼&µ°■Oì£▀q▀e\x04lW"
  b"k:T#ÙzEu P7º_ž\x02\v"
  b"ö\e╦Å\x03¹M═ª¯ßvî\x1C░é"
  b"ÄÕG•°òBÑ’;\x00ÿ™–\x18\x07"
  b"ãÙßóÉÃF\t¶×2u’Wu±"
  b"õÉðÔ×DK¥ø\x03øäå¢\x05v"
  b"""
    éœ\rZ¯çD`žM›°\n
    üw'
    """
  b"÷—õ\x0Fw<H{­•D»\x01&‡5"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.64 ms
(2.63%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.59 ms
(2.54%) 		1 
SELECT item_rounding FROM currency WHERE id = ?
Parameters: 
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(1.45%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.