Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.13 ms
(82.98%)
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
  114712
  413801
  425554
  445540
  446020
  446828
  447936
  452557
  452577
  453468
  454043
  455549
  458211
  458471
  462402
  465819
  471782
  479539
  483286
  489171
  489414
  490785
  493333
  494327
  497892
  502284
  504825
  505547
  506704
  506775
  508502
  508830
  511055
  511506
  512036
  512828
  517066
  518490
  519017
  521275
  521922
  523836
  525114
  525123
  527994
  528380
  529150
  530833
  531550
  531920
  532349
  533013
  533468
  535672
  540500
  543456
  546038
  549486
  551446
  551632
  554161
  554272
  554467
  555111
  555142
  558359
  558548
  558586
  559112
  559201
  560584
  561973
  565713
  565922
  566337
  570863
  572860
  575206
  577645
  577895
  577917
  578493
  579132
  583478
  584492
  585143
  587904
  589628
  593469
  593966
  594906
  595854
  595978
  596445
  596911
  599164
  599772
  600577
  603894
  604102
  604434
  605253
  605879
  610766
  613855
  615643
  616864
  618754
  620851
  621651
  624044
  625771
  649730
  657271
  663449
  666784
  668464
  677362
  677744
  677973
]
16.49 ms
(10.93%)
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
  570863
  605879
  604102
  533468
  677744
  489414
  616864
  593469
  479539
  506704
  594906
  543456
  657271
  533013
  546038
  620851
  577645
  559201
  618754
  490785
  558548
  519017
  584492
  666784
  453468
  555142
  462402
  506775
  560584
  565922
  589628
  603894
  465819
  511055
  518490
  532349
  599164
  595978
  455549
  583478
  610766
  512036
  605253
  525114
  677973
  508502
  528380
  505547
  621651
  663449
  540500
  599772
  523836
  458211
  566337
  649730
  677362
  624044
  413801
  561973
  530833
  454043
  471782
  529150
  551446
  572860
  577895
  578493
  554467
  554161
  575206
  604434
  615643
  625771
  452557
  425554
  535672
  483286
  531550
  114712
  511506
  521922
  521275
  525123
  579132
  551632
  565713
  555111
  558359
  613855
  596445
  596911
  447936
  502284
  512828
  585143
  458471
  494327
  452577
  497892
  489171
  508830
  554272
  549486
  595854
  493333
  446020
  577917
  587904
  558586
  600577
  593966
  668464
  446828
  445540
  517066
  531920
  504825
  527994
  559112
]
2.46 ms
(1.63%)
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
  114712
  413801
  425554
  445540
  446020
  446828
  447936
  452557
  452577
  453468
  454043
  455549
  458211
  458471
  462402
  465819
  471782
  479539
  483286
  489171
  489414
  490785
  493333
  494327
  497892
  502284
  504825
  505547
  506704
  506775
  508502
  508830
  511055
  511506
  512036
  512828
  517066
  518490
  519017
  521275
  521922
  523836
  525114
  525123
  527994
  528380
  529150
  530833
  531550
  531920
  532349
  533013
  533468
  535672
  540500
  543456
  546038
  549486
  551446
  551632
  554161
  554272
  554467
  555111
  555142
  558359
  558548
  558586
  559112
  559201
  560584
  561973
  565713
  565922
  566337
  570863
  572860
  575206
  577645
  577895
  577917
  578493
  579132
  583478
  584492
  585143
  587904
  589628
  593469
  593966
  594906
  595854
  595978
  596445
  596911
  599164
  599772
  600577
  603894
  604102
  604434
  605253
  605879
  610766
  613855
  615643
  616864
  618754
  620851
  621651
  624044
  625771
  649730
  657271
  663449
  666784
  668464
  677362
  677744
  677973
]
1.96 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob thong"
]
1.65 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс стринг нижн бел"
]
1.49 ms
(0.99%)
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.