Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.99 ms
(82.62%)
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
  20617
  123614
  383338
  387682
  390991
  394103
  405894
  407156
  409784
  419840
  422523
  425466
  429068
  429635
  430270
  430444
  431484
  431660
  435726
  443274
  443550
  443600
  446476
  458327
  463750
  464949
  471822
  473372
  479277
  480363
  485576
  486018
  486759
  489806
  492414
  494402
  494510
  500565
  508769
  510581
  512182
  517857
  519907
  525176
  525178
  526090
  539942
  540206
  550615
  550637
  550717
  550769
  551984
  552008
  552041
  552931
  554419
  554424
  555821
  556607
  557518
  557537
  558377
  559889
  559898
  560215
  564585
  565985
  565997
  566002
  566849
  572373
  572736
  573566
  585159
  586588
  599602
  601024
  603144
  614529
  617921
  622197
  622200
  623502
  623542
  623564
  623813
  623814
  624814
  628161
  630533
  647945
  654624
  679061
  679367
  688560
  695199
  699602
  704335
  712089
  715501
  717947
  731957
  735387
  737106
  737927
  745892
  752155
  754784
  754877
  759537
  790884
  793633
  797801
  805103
  809157
  814778
  821745
  823295
]
16.62 ms
(10.99%)
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
  623542
  793633
  805103
  745892
  754877
  754784
  704335
  715501
  20617
  473372
  737927
  383338
  405894
  431484
  435726
  446476
  525178
  525176
  539942
  500565
  551984
  552041
  554419
  550637
  556607
  558377
  550717
  552008
  557518
  566849
  573566
  628161
  585159
  603144
  586588
  601024
  622197
  623564
  623502
  123614
  463750
  394103
  422523
  471822
  429635
  430270
  494402
  489806
  557537
  458327
  519907
  623813
  486018
  550615
  419840
  814778
  480363
  647945
  654624
  695199
  624814
  623814
  797801
  731957
  486759
  407156
  443550
  443600
  517857
  485576
  508769
  823295
  540206
  512182
  552931
  559898
  679061
  679367
  688560
  712089
  717947
  559889
  565985
  622200
  614529
  599602
  627735
  737106
  759537
  735387
  699602
  560215
  630533
  430444
  809157
  821745
  479277
  555821
  790884
  425466
  387682
  429068
  492414
  464949
  494510
  526090
  565997
  566002
  550769
  564585
  554424
  572373
  572736
  617921
  752155
  390991
  431660
  443274
  409784
  510581
]
3.11 ms
(2.06%)
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
  20617
  123614
  383338
  387682
  390991
  394103
  405894
  407156
  409784
  419840
  422523
  425466
  429068
  429635
  430270
  430444
  431484
  431660
  435726
  443274
  443550
  443600
  446476
  458327
  463750
  464949
  471822
  473372
  479277
  480363
  485576
  486018
  486759
  489806
  492414
  494402
  494510
  500565
  508769
  510581
  512182
  517857
  519907
  525176
  525178
  526090
  539942
  540206
  550615
  550637
  550717
  550769
  551984
  552008
  552041
  552931
  554419
  554424
  555821
  556607
  557518
  557537
  558377
  559889
  559898
  560215
  564585
  565985
  565997
  566002
  566849
  572373
  572736
  573566
  585159
  586588
  599602
  601024
  603144
  614529
  617921
  622197
  622200
  623502
  623542
  623564
  623813
  623814
  624814
  628161
  630533
  647945
  654624
  679061
  679367
  688560
  695199
  699602
  704335
  712089
  715501
  717947
  731957
  735387
  737106
  737927
  745892
  752155
  754784
  754877
  759537
  790884
  793633
  797801
  805103
  809157
  814778
  821745
  823295
]
2.18 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lick pussy asian"
]
1.64 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза pussy азиатк"
]
1.24 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза pussy азиатк"
]

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.