Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.10 ms
(82.15%)
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
  204605
  365924
  384911
  399622
  402530
  406342
  421482
  422096
  428849
  429434
  433867
  437244
  438929
  438972
  442985
  446064
  451161
  453870
  456262
  457582
  459752
  463289
  463710
  464502
  466042
  466958
  469749
  472817
  475032
  479167
  484038
  486708
  487557
  488409
  492576
  494323
  497565
  498734
  502663
  504102
  504809
  508750
  510371
  511141
  513664
  514276
  515833
  516012
  519657
  521596
  531412
  533256
  534040
  535427
  536525
  537424
  539318
  542002
  542600
  542959
  545820
  547561
  548227
  550996
  556472
  560269
  560777
  562275
  562277
  562708
  564688
  570013
  571219
  571932
  572322
  572445
  572523
  573674
  578817
  589315
  601194
  604726
  605872
  605918
  607123
  613239
  613365
  637522
  639252
  649964
  651611
  668437
  678166
  687431
  689616
  693246
  710343
  717620
  720743
  777173
  777921
  778471
  778623
  778994
  780030
  783235
  784744
  784755
  786359
  787896
  794091
  801026
  802120
  804982
  805242
  806842
  806919
  816755
  816963
  821044
]
17.13 ms
(10.99%)
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
  777173
  777921
  778623
  784744
  402530
  421482
  437244
  399622
  433867
  204605
  442985
  463289
  365924
  429434
  466042
  456262
  494323
  498734
  486708
  504809
  514276
  539318
  605918
  466958
  422096
  438929
  446064
  438972
  469749
  472817
  504102
  521596
  484038
  488409
  510371
  513664
  519657
  492576
  497565
  502663
  511141
  515833
  384911
  406342
  428849
  816963
  821044
  816755
  463710
  464502
  453870
  459752
  479167
  451161
  457582
  475032
  487557
  533256
  516012
  536525
  508750
  531412
  537424
  534040
  535427
  542002
  550996
  556472
  560269
  560777
  562277
  571932
  572322
  542600
  562275
  562708
  572445
  572523
  573674
  542959
  545820
  548227
  578817
  649964
  668437
  693246
  717620
  651611
  689616
  720743
  678166
  687431
  710343
  547561
  564688
  570013
  571219
  589315
  607123
  637522
  639252
  604726
  613239
  601194
  605872
  613365
  778471
  778994
  784755
  804982
  805242
  806919
  780030
  783235
  786359
  787896
  794091
  801026
  802120
  806842
]
3.09 ms
(1.98%)
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
  204605
  365924
  384911
  399622
  402530
  406342
  421482
  422096
  428849
  429434
  433867
  437244
  438929
  438972
  442985
  446064
  451161
  453870
  456262
  457582
  459752
  463289
  463710
  464502
  466042
  466958
  469749
  472817
  475032
  479167
  484038
  486708
  487557
  488409
  492576
  494323
  497565
  498734
  502663
  504102
  504809
  508750
  510371
  511141
  513664
  514276
  515833
  516012
  519657
  521596
  531412
  533256
  534040
  535427
  536525
  537424
  539318
  542002
  542600
  542959
  545820
  547561
  548227
  550996
  556472
  560269
  560777
  562275
  562277
  562708
  564688
  570013
  571219
  571932
  572322
  572445
  572523
  573674
  578817
  589315
  601194
  604726
  605872
  605918
  607123
  613239
  613365
  637522
  639252
  649964
  651611
  668437
  678166
  687431
  689616
  693246
  710343
  717620
  720743
  777173
  777921
  778471
  778623
  778994
  780030
  783235
  784744
  784755
  786359
  787896
  794091
  801026
  802120
  804982
  805242
  806842
  806919
  816755
  816963
  821044
]
2.03 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð║ð¥ð╗ð│ð¥Ðéð║ð© ð║ÐÇð░Ðüð©ð▓ÐïðÁ ð┐ð¥ðÔÔǪ"
]
1.89 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "колготк красивая"
]
1.81 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.