Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.34 ms
(86.63%)
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
  125809
  407054
  432641
  435488
  443255
  445661
  446031
  446034
  451129
  452304
  455808
  463852
  464206
  465719
  467011
  478931
  494447
  496624
  517528
  518766
  526086
  534633
  561458
  561468
  561512
  565700
  565716
  565737
  584385
  588404
  589067
  589696
  593064
  593073
  606931
  607011
  628518
  637402
  656219
  703458
  708029
  712686
  712777
  713853
  721870
  722099
  723573
  724109
  725211
  726497
  726498
  726506
  726515
  726535
  726589
  726590
  726594
  726596
  726673
  726711
  727016
  727576
  727805
  730342
  730758
  731014
  731086
  731372
  732913
  733499
  734165
  735017
  735829
  736741
  737182
  737185
  737561
  738203
  738281
  738679
  739675
  740129
  740698
  740824
  740869
  742764
  742809
  742959
  746021
  750093
  750257
  750852
  756431
  756719
  759013
  759722
  759908
  760249
  760599
  761505
  762383
  762437
  766616
  767105
  767163
  767268
  767272
  767609
  769291
  770522
  771835
  776617
  784822
  795770
  796162
  799988
  807742
  824347
  824423
  825419
]
15.30 ms
(7.69%)
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
  713853
  628518
  799988
  724109
  726497
  726711
  759013
  731014
  731086
  733499
  740129
  750257
  736741
  742764
  762383
  726498
  731372
  735017
  740698
  756719
  761505
  767268
  771835
  721870
  807742
  467011
  465719
  451129
  561458
  726589
  526086
  494447
  584385
  588404
  607011
  606931
  727805
  759908
  561468
  561512
  565737
  589696
  593073
  726673
  726594
  432641
  703458
  712686
  708029
  796162
  762437
  725211
  740824
  760249
  726515
  727016
  732913
  737182
  739675
  750852
  767609
  760599
  770522
  795770
  407054
  435488
  443255
  445661
  446034
  464206
  452304
  518766
  478931
  656219
  769291
  446031
  517528
  565700
  565716
  637402
  593064
  766616
  455808
  125809
  723573
  824347
  825419
  824423
  463852
  534633
  496624
  712777
  722099
  589067
  776617
  784822
  726506
  727576
  737561
  740869
  767272
  738203
  738281
  767105
  767163
  726535
  737185
  738679
  746021
  730342
  730758
  734165
  735829
  742959
  759722
  726590
  726596
  742809
  750093
  756431
]
3.89 ms
(1.96%)
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
  125809
  407054
  432641
  435488
  443255
  445661
  446031
  446034
  451129
  452304
  455808
  463852
  464206
  465719
  467011
  478931
  494447
  496624
  517528
  518766
  526086
  534633
  561458
  561468
  561512
  565700
  565716
  565737
  584385
  588404
  589067
  589696
  593064
  593073
  606931
  607011
  628518
  637402
  656219
  703458
  708029
  712686
  712777
  713853
  721870
  722099
  723573
  724109
  725211
  726497
  726498
  726506
  726515
  726535
  726589
  726590
  726594
  726596
  726673
  726711
  727016
  727576
  727805
  730342
  730758
  731014
  731086
  731372
  732913
  733499
  734165
  735017
  735829
  736741
  737182
  737185
  737561
  738203
  738281
  738679
  739675
  740129
  740698
  740824
  740869
  742764
  742809
  742959
  746021
  750093
  750257
  750852
  756431
  756719
  759013
  759722
  759908
  760249
  760599
  761505
  762383
  762437
  766616
  767105
  767163
  767268
  767272
  767609
  769291
  770522
  771835
  776617
  784822
  795770
  796162
  799988
  807742
  824347
  824423
  825419
]
2.28 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск mature латинская"
]
1.82 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur mature latina"
]
1.78 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск mature латинская"
]

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.