Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.32 ms
(83.08%)
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
  4131
  7051
  74830
  102441
  157617
  177496
  181184
  365938
  379777
  382032
  383107
  383355
  384542
  384798
  384888
  384984
  385782
  386625
  387014
  387318
  388115
  389157
  392393
  393526
  396215
  397876
  402793
  416241
  419667
  420094
  420526
  420881
  424524
  424812
  428319
  430936
  431228
  436510
  444586
  452286
  454697
  454973
  457217
  458587
  470867
  473235
  473910
  476844
  482326
  485262
  489032
  500302
  513135
  515199
  515201
  519978
  523150
  523906
  537001
  538216
  540543
  543510
  548780
  549943
  550610
  554647
  555847
  555850
  556324
  556858
  558072
  558432
  559837
  560302
  561820
  561853
  566247
  568581
  568621
  570595
  573614
  576100
  584506
  587637
  591070
  593883
  595011
  595022
  595682
  595755
  597852
  598851
  603148
  603549
  609729
  616973
  622830
  623815
  625991
  645663
  649080
  654417
  663863
  664841
  674269
  675025
  679355
  679702
  682530
  682902
  684547
  689498
  701302
  710832
  724418
  750525
  793595
  800579
  826696
  827963
]
17.90 ms
(10.75%)
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
  701302
  424524
  549943
  625991
  379777
  679355
  157617
  800579
  555850
  4131
  548780
  485262
  430936
  664841
  515199
  550610
  750525
  102441
  384542
  682530
  609729
  482326
  684547
  436510
  576100
  388115
  523150
  679702
  556324
  523906
  710832
  558072
  393526
  402793
  420094
  682902
  570595
  396215
  538216
  383107
  543510
  385782
  654417
  561853
  473235
  649080
  616973
  560302
  566247
  595011
  595755
  597852
  181184
  689498
  554647
  458587
  724418
  420526
  384798
  593883
  382032
  595682
  519978
  428319
  365938
  591070
  573614
  387014
  452286
  454697
  675025
  540543
  397876
  674269
  584506
  470867
  419667
  513135
  420881
  424812
  476844
  416241
  622830
  587637
  645663
  384888
  558432
  389157
  444586
  387318
  384984
  555847
  568581
  556858
  473910
  603148
  561820
  7051
  74830
  603549
  537001
  623815
  431228
  827963
  386625
  177496
  383355
  454973
  457217
  598851
  515201
  568621
  663863
  489032
  826696
  595022
  793595
  559837
  392393
  500302
]
2.50 ms
(1.50%)
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
  4131
  7051
  74830
  102441
  157617
  177496
  181184
  365938
  379777
  382032
  383107
  383355
  384542
  384798
  384888
  384984
  385782
  386625
  387014
  387318
  388115
  389157
  392393
  393526
  396215
  397876
  402793
  416241
  419667
  420094
  420526
  420881
  424524
  424812
  428319
  430936
  431228
  436510
  444586
  452286
  454697
  454973
  457217
  458587
  470867
  473235
  473910
  476844
  482326
  485262
  489032
  500302
  513135
  515199
  515201
  519978
  523150
  523906
  537001
  538216
  540543
  543510
  548780
  549943
  550610
  554647
  555847
  555850
  556324
  556858
  558072
  558432
  559837
  560302
  561820
  561853
  566247
  568581
  568621
  570595
  573614
  576100
  584506
  587637
  591070
  593883
  595011
  595022
  595682
  595755
  597852
  598851
  603148
  603549
  609729
  616973
  622830
  623815
  625991
  645663
  649080
  654417
  663863
  664841
  674269
  675025
  679355
  679702
  682530
  682902
  684547
  689498
  701302
  710832
  724418
  750525
  793595
  800579
  826696
  827963
]
2.07 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни девушка верхом"
]
1.98 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс девушк наездниц поз"
]
1.92 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс девушк наездниц поз"
]
1.79 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.