Query Metrics

7 Database Queries
7 Different statements
145.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
119.23 ms
(81.86%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  20190
  87974
  209216
  349135
  392848
  396707
  397478
  415300
  416032
  416537
  416686
  416695
  416737
  417348
  427539
  428253
  428255
  441102
  443317
  448370
  456700
  457476
  457483
  459203
  466427
  467715
  469080
  469221
  471671
  471685
  471687
  476166
  477587
  486768
  487425
  505140
  505368
  505382
  509422
  514248
  514854
  514876
  517509
  529897
  530674
  531222
  532732
  533544
  534535
  534548
  534578
  535467
  536227
  540509
  541328
  544132
  544143
  545222
  545376
  545415
  547453
  547465
  547471
  550899
  556899
  559289
  559359
  572655
  575859
  576503
  576548
  593274
  597163
  613032
  614355
  619607
  621682
  634100
  634109
  648673
  660365
  662856
  663306
  664193
  666898
  669565
  672850
  677295
  680252
  703574
  709562
  710877
  713184
  722377
  722392
  724580
  729691
  730074
  738814
  740932
  742363
  745086
  749282
  749672
  751710
  751773
  752598
  752655
  752673
  752784
  757445
  761625
  770225
  778427
  784775
  786850
  786873
  791047
  809364
  814519
]
16.57 ms
(11.38%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  669565
  660365
  593274
  634100
  634109
  729691
  757445
  749672
  710877
  20190
  209216
  471671
  467715
  749282
  514876
  791047
  505382
  469221
  677295
  738814
  477587
  415300
  448370
  457476
  476166
  576503
  547471
  751773
  752598
  87974
  459203
  471685
  536227
  648673
  417348
  349135
  545376
  770225
  443317
  428253
  416695
  457483
  614355
  597163
  730074
  416686
  509422
  396707
  722392
  416032
  514248
  416537
  505368
  514854
  534535
  544143
  664193
  778427
  752655
  761625
  397478
  471687
  533544
  530674
  534548
  466427
  559289
  575859
  545222
  556899
  544132
  672850
  703574
  713184
  662856
  663306
  666898
  680252
  709562
  722377
  545415
  572655
  576548
  619607
  613032
  621682
  786850
  784775
  786873
  809364
  740932
  751710
  752673
  724580
  742363
  745086
  752784
  392848
  416737
  427539
  428255
  441102
  814519
  469080
  456700
  505140
  531222
  517509
  535467
  529897
  532732
  534578
  540509
  486768
  487425
  547465
  559359
  541328
  547453
  550899
]
2.55 ms
(1.75%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  20190
  87974
  209216
  349135
  392848
  396707
  397478
  415300
  416032
  416537
  416686
  416695
  416737
  417348
  427539
  428253
  428255
  441102
  443317
  448370
  456700
  457476
  457483
  459203
  466427
  467715
  469080
  469221
  471671
  471685
  471687
  476166
  477587
  486768
  487425
  505140
  505368
  505382
  509422
  514248
  514854
  514876
  517509
  529897
  530674
  531222
  532732
  533544
  534535
  534548
  534578
  535467
  536227
  540509
  541328
  544132
  544143
  545222
  545376
  545415
  547453
  547465
  547471
  550899
  556899
  559289
  559359
  572655
  575859
  576503
  576548
  593274
  597163
  613032
  614355
  619607
  621682
  634100
  634109
  648673
  660365
  662856
  663306
  664193
  666898
  669565
  672850
  677295
  680252
  703574
  709562
  710877
  713184
  722377
  722392
  724580
  729691
  730074
  738814
  740932
  742363
  745086
  749282
  749672
  751710
  751773
  752598
  752655
  752673
  752784
  757445
  761625
  770225
  778427
  784775
  786850
  786873
  791047
  809364
  814519
]
2.26 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal extreme toys"
]
1.95 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал хардкор toys"
]
1.45 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал хардкор toys"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.