Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.30 ms
(85.35%)
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
  381424
  388894
  392674
  399621
  400473
  402016
  408179
  411133
  421211
  424995
  427418
  437323
  438501
  442573
  442650
  442661
  457669
  462357
  463151
  466630
  469083
  469231
  472335
  472852
  473132
  473213
  475641
  477364
  479470
  482876
  484544
  488525
  489725
  490757
  491980
  498412
  508058
  509459
  510555
  514094
  517365
  517879
  519176
  523732
  524134
  524697
  525732
  527177
  527871
  528568
  528671
  528839
  529481
  529948
  532252
  534741
  535698
  536393
  537880
  541121
  541732
  544109
  544779
  545965
  546373
  546937
  546975
  548403
  551612
  555327
  555821
  557434
  558744
  559297
  559702
  559997
  561071
  561273
  561507
  562469
  564271
  564493
  564771
  566083
  568363
  568891
  571844
  571889
  577051
  580012
  580081
  580555
  581198
  584527
  584895
  588386
  588439
  591361
  597590
  598934
  599007
  600800
  604978
  607391
  607412
  610952
  617042
  617672
  620567
  627532
  636116
  642132
  647255
  666971
  674516
  678015
  682686
  720609
  799456
]
16.16 ms
(8.44%)
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
  517365
  400473
  402016
  437323
  438501
  442661
  442650
  535698
  462357
  473213
  477364
  490757
  523732
  524134
  529948
  525732
  534741
  514094
  528671
  472852
  482876
  544779
  546373
  546937
  555327
  564771
  541121
  546975
  548403
  558744
  559297
  559702
  564271
  584527
  555656
  566083
  568891
  580012
  584895
  682686
  647255
  674516
  571889
  580081
  588386
  591361
  600800
  627532
  610952
  597590
  617042
  636116
  588439
  599007
  607391
  617672
  620567
  642132
  799456
  604978
  607412
  720609
  381424
  399621
  411133
  469231
  475641
  466630
  469083
  473132
  427418
  392674
  457669
  472335
  421211
  479470
  509459
  491980
  488525
  489725
  508058
  519176
  524697
  498412
  532252
  564493
  561273
  577051
  527871
  536393
  555821
  442573
  388894
  424995
  408179
  666971
  484544
  510555
  517879
  527177
  537880
  528568
  528839
  529481
  463151
  541732
  544109
  545965
  557434
  580555
  581198
  559997
  571844
  678015
  551612
  561071
  561507
  562469
  568363
  598934
]
3.80 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
  381424
  388894
  392674
  399621
  400473
  402016
  408179
  411133
  421211
  424995
  427418
  437323
  438501
  442573
  442650
  442661
  457669
  462357
  463151
  466630
  469083
  469231
  472335
  472852
  473132
  473213
  475641
  477364
  479470
  482876
  484544
  488525
  489725
  490757
  491980
  498412
  508058
  509459
  510555
  514094
  517365
  517879
  519176
  523732
  524134
  524697
  525732
  527177
  527871
  528568
  528671
  528839
  529481
  529948
  532252
  534741
  535698
  536393
  537880
  541121
  541732
  544109
  544779
  545965
  546373
  546937
  546975
  548403
  551612
  555327
  555821
  557434
  558744
  559297
  559702
  559997
  561071
  561273
  561507
  562469
  564271
  564493
  564771
  566083
  568363
  568891
  571844
  571889
  577051
  580012
  580081
  580555
  581198
  584527
  584895
  588386
  588439
  591361
  597590
  598934
  599007
  600800
  604978
  607391
  607412
  610952
  617042
  617672
  620567
  627532
  636116
  642132
  647255
  666971
  674516
  678015
  682686
  720609
  799456
]
2.44 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "виды вагин"
]
1.97 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вид вагин"
]
1.70 ms
(0.89%)
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.