Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.42 ms
(82.68%)
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
  38452
  95742
  191093
  387536
  390111
  390938
  395592
  395861
  396057
  396656
  397675
  399295
  399689
  400453
  405438
  407657
  410251
  410353
  411033
  411199
  411451
  412208
  413234
  413434
  413703
  416441
  416647
  416707
  419410
  420116
  423513
  424160
  425117
  425306
  425519
  428685
  429263
  429286
  429483
  431176
  431302
  431636
  431647
  435799
  437434
  438323
  438335
  445551
  446618
  447690
  451712
  454088
  454674
  458539
  458840
  460036
  462193
  462681
  463443
  467336
  468475
  468587
  470345
  470509
  471580
  474101
  474292
  474447
  477410
  481187
  484837
  489584
  489909
  490815
  490824
  496537
  504995
  506359
  509079
  513340
  518048
  519717
  521451
  521942
  526941
  527167
  534724
  542207
  562298
  567081
  568356
  571898
  572152
  580688
  580864
  581048
  588846
  589112
  607165
  618401
  668607
  668869
  670102
  675281
  697150
  702635
  713014
  714448
  716274
  721744
  730751
  741531
  759609
  766121
  770105
  775774
  787530
  791218
  809328
  816116
]
18.74 ms
(11.19%)
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
  490824
  581048
  668869
  809328
  766121
  730751
  759609
  412208
  816116
  425306
  713014
  399295
  38452
  467336
  468475
  431647
  454088
  387536
  460036
  446618
  521942
  474101
  429286
  411451
  419410
  431302
  489909
  775774
  791218
  399689
  395861
  410251
  518048
  471580
  697150
  716274
  395592
  451712
  424160
  519717
  470345
  787530
  668607
  562298
  490815
  481187
  458840
  437434
  405438
  496537
  191093
  410353
  429483
  413434
  423513
  580864
  542207
  670102
  607165
  618401
  770105
  702635
  397675
  411033
  411199
  504995
  513340
  572152
  589112
  534724
  462193
  477410
  438335
  400453
  506359
  431636
  445551
  428685
  435799
  454674
  416441
  489584
  95742
  396656
  416707
  413703
  470509
  468587
  458539
  567081
  675281
  568356
  741531
  714448
  447690
  425117
  463443
  474447
  396057
  509079
  527167
  474292
  580688
  571898
  588846
  425519
  407657
  416647
  438323
  521451
  526941
  484837
  413234
  431176
  462681
  721744
  420116
  390111
  390938
  429263
]
2.68 ms
(1.60%)
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
  38452
  95742
  191093
  387536
  390111
  390938
  395592
  395861
  396057
  396656
  397675
  399295
  399689
  400453
  405438
  407657
  410251
  410353
  411033
  411199
  411451
  412208
  413234
  413434
  413703
  416441
  416647
  416707
  419410
  420116
  423513
  424160
  425117
  425306
  425519
  428685
  429263
  429286
  429483
  431176
  431302
  431636
  431647
  435799
  437434
  438323
  438335
  445551
  446618
  447690
  451712
  454088
  454674
  458539
  458840
  460036
  462193
  462681
  463443
  467336
  468475
  468587
  470345
  470509
  471580
  474101
  474292
  474447
  477410
  481187
  484837
  489584
  489909
  490815
  490824
  496537
  504995
  506359
  509079
  513340
  518048
  519717
  521451
  521942
  526941
  527167
  534724
  542207
  562298
  567081
  568356
  571898
  572152
  580688
  580864
  581048
  588846
  589112
  607165
  618401
  668607
  668869
  670102
  675281
  697150
  702635
  713014
  714448
  716274
  721744
  730751
  741531
  759609
  766121
  770105
  775774
  787530
  791218
  809328
  816116
]
2.06 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красивая блондинка с …"
]
1.91 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая беловолосая"
]
1.65 ms
(0.98%)
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.