Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.47 ms
(83.34%)
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
  420125
  421017
  459901
  464854
  474569
  477529
  487774
  491786
  494255
  495393
  495756
  496148
  496301
  502894
  503464
  510812
  510898
  512094
  513572
  513845
  513894
  515617
  515634
  516227
  517732
  519194
  519262
  519349
  519650
  520161
  520319
  520710
  523766
  525196
  525415
  525430
  525769
  526121
  526189
  526553
  526727
  531943
  533534
  534688
  541230
  541240
  541379
  541535
  542565
  543844
  544311
  549497
  549976
  551761
  552270
  554793
  558440
  560851
  561397
  564173
  566782
  569020
  570695
  570867
  571028
  571130
  571773
  580353
  581988
  583757
  583982
  585618
  587749
  587964
  588043
  589254
  590716
  592489
  592973
  592974
  593060
  594606
  595801
  596243
  596541
  596929
  599621
  601141
  603254
  603743
  604172
  605007
  605670
  606218
  607261
  609531
  610600
  611366
  619644
  626760
  628170
  628622
  629428
  630092
  630317
  631880
  633527
  636656
  664542
  678095
  678097
  678716
  681691
  682270
  688108
  731244
  749063
  750732
  750896
  803129
]
16.78 ms
(9.89%)
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
  633527
  585618
  596243
  611366
  628622
  631880
  636656
  587749
  589254
  593060
  605670
  606218
  750732
  749063
  750896
  731244
  630317
  474569
  494255
  519262
  525415
  515634
  525769
  503464
  682270
  605007
  630092
  502894
  571773
  420125
  491786
  542565
  681691
  520710
  629428
  459901
  526553
  531943
  541379
  526727
  487774
  549976
  580353
  626760
  609531
  596929
  421017
  519650
  525430
  517732
  541240
  552270
  541230
  516227
  519349
  523766
  526189
  544311
  541535
  551761
  570695
  570867
  678716
  592973
  601141
  619644
  592974
  595801
  596541
  599621
  603254
  628170
  594606
  803129
  610600
  560851
  664542
  590716
  515617
  564173
  592489
  571028
  688108
  566782
  604172
  533534
  495393
  513572
  510898
  519194
  603743
  543844
  678095
  583982
  607261
  512094
  678097
  558440
  513845
  464854
  520161
  496148
  513894
  526121
  495756
  510812
  520319
  525196
  571130
  587964
  588043
  534688
  496301
  477529
  554793
  561397
  569020
  581988
  583757
  549497
]
3.38 ms
(1.99%)
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
  420125
  421017
  459901
  464854
  474569
  477529
  487774
  491786
  494255
  495393
  495756
  496148
  496301
  502894
  503464
  510812
  510898
  512094
  513572
  513845
  513894
  515617
  515634
  516227
  517732
  519194
  519262
  519349
  519650
  520161
  520319
  520710
  523766
  525196
  525415
  525430
  525769
  526121
  526189
  526553
  526727
  531943
  533534
  534688
  541230
  541240
  541379
  541535
  542565
  543844
  544311
  549497
  549976
  551761
  552270
  554793
  558440
  560851
  561397
  564173
  566782
  569020
  570695
  570867
  571028
  571130
  571773
  580353
  581988
  583757
  583982
  585618
  587749
  587964
  588043
  589254
  590716
  592489
  592973
  592974
  593060
  594606
  595801
  596243
  596541
  596929
  599621
  601141
  603254
  603743
  604172
  605007
  605670
  606218
  607261
  609531
  610600
  611366
  619644
  626760
  628170
  628622
  629428
  630092
  630317
  631880
  633527
  636656
  664542
  678095
  678097
  678716
  681691
  682270
  688108
  731244
  749063
  750732
  750896
  803129
]
2.10 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"большой клитор у мамкÐ…"
]
2.05 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие клитор мам женщин"
]
1.97 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие клитор мам женщин"
]

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.