Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.88 ms
(84.63%)
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
  392404
  410308
  428849
  429419
  436393
  437597
  444134
  444717
  445187
  448781
  453870
  459614
  463710
  465972
  469753
  475032
  477823
  478123
  478125
  478129
  480510
  480705
  486892
  487428
  491188
  492332
  492758
  493113
  495292
  495670
  496968
  499707
  500391
  502967
  505634
  506093
  508750
  511545
  511677
  513091
  513501
  516012
  519055
  520456
  521093
  522355
  523773
  524436
  529456
  531412
  533256
  534040
  535427
  536525
  536819
  537424
  542002
  542600
  542959
  547561
  548227
  552539
  556574
  560063
  562275
  562277
  562708
  564688
  567365
  567860
  568643
  570013
  571219
  571706
  571932
  572322
  572445
  572523
  573674
  578817
  584793
  585328
  591219
  591380
  601194
  604726
  605872
  613239
  613365
  637522
  639252
  649964
  651611
  668437
  677357
  678166
  687431
  693246
  710343
  717620
  720743
  754160
  778471
  778994
  780030
  783235
  784755
  786359
  787896
  794091
  801026
  802120
  804982
  805242
  806842
  806919
  812573
  816755
  816963
  821044
]
15.28 ms
(9.24%)
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
  477823
  480705
  469753
  444134
  465972
  478125
  487428
  493113
  495292
  500391
  492332
  492758
  502967
  513501
  521093
  524436
  529456
  491188
  522355
  571706
  560063
  568643
  436393
  445187
  410308
  429419
  556574
  584793
  567365
  552539
  567860
  585328
  591380
  591219
  437597
  480510
  444717
  478123
  392404
  459614
  478129
  505634
  511545
  520456
  523773
  536819
  513091
  496968
  499707
  511677
  486892
  495670
  448781
  506093
  519055
  677357
  428849
  816963
  821044
  816755
  463710
  453870
  475032
  533256
  516012
  536525
  508750
  531412
  537424
  534040
  535427
  542002
  562277
  571932
  572322
  542600
  562275
  562708
  572445
  572523
  573674
  542959
  548227
  578817
  649964
  668437
  693246
  717620
  651611
  720743
  678166
  687431
  710343
  547561
  564688
  570013
  571219
  637522
  639252
  604726
  613239
  601194
  605872
  613365
  778471
  778994
  784755
  804982
  805242
  806919
  780030
  783235
  786359
  787896
  794091
  801026
  802120
  806842
  812573
  754160
]
2.88 ms
(1.74%)
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
  392404
  410308
  428849
  429419
  436393
  437597
  444134
  444717
  445187
  448781
  453870
  459614
  463710
  465972
  469753
  475032
  477823
  478123
  478125
  478129
  480510
  480705
  486892
  487428
  491188
  492332
  492758
  493113
  495292
  495670
  496968
  499707
  500391
  502967
  505634
  506093
  508750
  511545
  511677
  513091
  513501
  516012
  519055
  520456
  521093
  522355
  523773
  524436
  529456
  531412
  533256
  534040
  535427
  536525
  536819
  537424
  542002
  542600
  542959
  547561
  548227
  552539
  556574
  560063
  562275
  562277
  562708
  564688
  567365
  567860
  568643
  570013
  571219
  571706
  571932
  572322
  572445
  572523
  573674
  578817
  584793
  585328
  591219
  591380
  601194
  604726
  605872
  613239
  613365
  637522
  639252
  649964
  651611
  668437
  677357
  678166
  687431
  693246
  710343
  717620
  720743
  754160
  778471
  778994
  780030
  783235
  784755
  786359
  787896
  794091
  801026
  802120
  804982
  805242
  806842
  806919
  812573
  816755
  816963
  821044
]
2.17 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красотки в колготках %…"
]
1.87 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая колготк"
]
1.73 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 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.