Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.08 ms
(59.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "girlfriend русск"
]
122.52 ms
(34.06%)
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
  422247
  423815
  424282
  434953
  436530
  445756
  448126
  453598
  455546
  459571
  461557
  462040
  462797
  465154
  465254
  465934
  469797
  470112
  479756
  481646
  481840
  482494
  483041
  484120
  484733
  485520
  488595
  488916
  490538
  491557
  492456
  492841
  493276
  494400
  495182
  495442
  496044
  500204
  505379
  506379
  506440
  507466
  507665
  508288
  509700
  511233
  511811
  512165
  513052
  518348
  521348
  521543
  521622
  521951
  523974
  524536
  525452
  527705
  544519
  544893
  546721
  546972
  548618
  548621
  550469
  550509
  551249
  552359
  553256
  553258
  554201
  556714
  558692
  559007
  563683
  567315
  567388
  567409
  569942
  572671
  574521
  577728
  587931
  588277
  590319
  591393
  591979
  594023
  601313
  601507
  604183
  608234
  610504
  610833
  613333
  621807
  623007
  623355
  624616
  626067
  628478
  628480
  635667
  641506
  647255
  659464
  667183
  672283
  677081
  679198
  690709
  710614
  712859
  723629
  737786
  758388
  776907
  779247
  783162
  788342
]
16.31 ms
(4.53%)
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
  424282
  462040
  461557
  495442
  506440
  507466
  485520
  488595
  488916
  518348
  572671
  482494
  511811
  500204
  552359
  553258
  567315
  567388
  567409
  659464
  610833
  588277
  590319
  594023
  601507
  628478
  587931
  459571
  469797
  455546
  462797
  479756
  434953
  470112
  481646
  423815
  445756
  448126
  422247
  465154
  465254
  508288
  511233
  521951
  484733
  492456
  492841
  494400
  495182
  507665
  513052
  527705
  484120
  493276
  496044
  506379
  509700
  521622
  524536
  483041
  490538
  491557
  505379
  512165
  521348
  521543
  436530
  465934
  453598
  525452
  523974
  723629
  481840
  546721
  548618
  558692
  559007
  544519
  546972
  550509
  553256
  554201
  556714
  563683
  569942
  544893
  550469
  551249
  574521
  667183
  672283
  677081
  647255
  679198
  690709
  710614
  712859
  548621
  577728
  591979
  621807
  601313
  604183
  626067
  641506
  610504
  623007
  624616
  628480
  591393
  608234
  613333
  623355
  635667
  776907
  788342
  779247
  783162
  737786
  758388
]
2.80 ms
(0.78%)
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
  422247
  423815
  424282
  434953
  436530
  445756
  448126
  453598
  455546
  459571
  461557
  462040
  462797
  465154
  465254
  465934
  469797
  470112
  479756
  481646
  481840
  482494
  483041
  484120
  484733
  485520
  488595
  488916
  490538
  491557
  492456
  492841
  493276
  494400
  495182
  495442
  496044
  500204
  505379
  506379
  506440
  507466
  507665
  508288
  509700
  511233
  511811
  512165
  513052
  518348
  521348
  521543
  521622
  521951
  523974
  524536
  525452
  527705
  544519
  544893
  546721
  546972
  548618
  548621
  550469
  550509
  551249
  552359
  553256
  553258
  554201
  556714
  558692
  559007
  563683
  567315
  567388
  567409
  569942
  572671
  574521
  577728
  587931
  588277
  590319
  591393
  591979
  594023
  601313
  601507
  604183
  608234
  610504
  610833
  613333
  621807
  623007
  623355
  624616
  626067
  628478
  628480
  635667
  641506
  647255
  659464
  667183
  672283
  677081
  679198
  690709
  710614
  712859
  723629
  737786
  758388
  776907
  779247
  783162
  788342
]
1.80 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girlfriend russian"
]
1.59 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "girlfriend русск"
]

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.