Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.11 ms
(84.72%)
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
  48235
  72822
  95855
  129999
  130289
  181397
  188337
  191400
  191575
  233340
  326290
  358887
  364655
  385062
  386636
  386759
  388421
  389713
  391920
  391928
  391929
  392061
  392277
  398426
  398957
  400820
  400928
  401927
  401935
  406109
  406616
  407274
  408278
  409795
  412273
  412541
  414134
  415050
  415221
  421848
  421899
  422145
  425014
  427487
  428124
  439463
  440824
  440956
  447474
  448363
  448802
  451112
  452037
  452052
  455301
  455599
  455906
  460807
  465040
  466164
  468123
  468707
  469447
  470174
  470941
  471450
  473525
  473950
  474825
  475904
  475984
  478455
  478587
  480392
  486868
  487383
  489987
  490848
  490886
  494703
  497879
  503385
  514908
  516021
  522510
  524389
  527570
  542950
  550380
  554976
  555093
  556018
  561845
  562997
  571035
  573726
  587846
  600314
  647955
  671725
  725570
  729678
  731449
  748231
  757438
  761589
  770284
  798643
  799127
  805908
  815391
  815470
  816016
  816241
  816250
  816529
  816887
  817765
  817786
  824915
]
14.47 ms
(8.63%)
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
  326290
  587846
  470941
  385062
  428124
  422145
  233340
  48235
  72822
  386636
  452052
  406616
  475904
  489987
  398957
  421848
  455599
  406109
  439463
  401935
  455301
  129999
  729678
  469447
  480392
  725570
  490848
  191400
  757438
  761589
  386759
  130289
  451112
  364655
  522510
  524389
  392277
  600314
  824915
  554976
  562997
  473525
  470174
  95855
  400928
  391928
  389713
  408278
  427487
  503385
  401927
  514908
  556018
  473950
  561845
  391920
  415050
  466164
  799127
  181397
  188337
  391929
  398426
  448802
  448363
  452037
  412541
  414134
  465040
  474825
  440956
  516021
  494703
  358887
  455906
  815470
  527570
  816016
  817765
  731449
  468123
  647955
  748231
  392061
  407274
  497879
  487383
  815391
  816241
  816250
  816529
  817786
  816887
  471450
  542950
  671725
  798643
  805908
  770284
  486868
  412273
  468707
  555093
  478455
  388421
  409795
  415221
  191575
  550380
  478587
  571035
  460807
  447474
  400820
  425014
  421899
  490886
  440824
  573726
  475984
]
2.83 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин минет оральн секс"
]
2.71 ms
(1.62%)
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
  48235
  72822
  95855
  129999
  130289
  181397
  188337
  191400
  191575
  233340
  326290
  358887
  364655
  385062
  386636
  386759
  388421
  389713
  391920
  391928
  391929
  392061
  392277
  398426
  398957
  400820
  400928
  401927
  401935
  406109
  406616
  407274
  408278
  409795
  412273
  412541
  414134
  415050
  415221
  421848
  421899
  422145
  425014
  427487
  428124
  439463
  440824
  440956
  447474
  448363
  448802
  451112
  452037
  452052
  455301
  455599
  455906
  460807
  465040
  466164
  468123
  468707
  469447
  470174
  470941
  471450
  473525
  473950
  474825
  475904
  475984
  478455
  478587
  480392
  486868
  487383
  489987
  490848
  490886
  494703
  497879
  503385
  514908
  516021
  522510
  524389
  527570
  542950
  550380
  554976
  555093
  556018
  561845
  562997
  571035
  573726
  587846
  600314
  647955
  671725
  725570
  729678
  731449
  748231
  757438
  761589
  770284
  798643
  799127
  805908
  815391
  815470
  816016
  816241
  816250
  816529
  816887
  817765
  817786
  824915
]
2.40 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother blowjob"
]
1.75 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.88%)
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.