Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.09 ms
(80.44%)
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
  1061
  101894
  226082
  364606
  385446
  389110
  397819
  401367
  402026
  413456
  414001
  415430
  422142
  425744
  426551
  429040
  434040
  434566
  437801
  443366
  445072
  447252
  447301
  448619
  450844
  453110
  454639
  457067
  457311
  458217
  458267
  459776
  460098
  460624
  460713
  460722
  461251
  461374
  461472
  461537
  461808
  467147
  467361
  468679
  468783
  469297
  469760
  470167
  470861
  474069
  474385
  475750
  475871
  479962
  481218
  482274
  482806
  483528
  483825
  485337
  485479
  489107
  489141
  490033
  491588
  493118
  494658
  495852
  497197
  497806
  499368
  499749
  501969
  502568
  502967
  504203
  505381
  508803
  509581
  510955
  512619
  512647
  512760
  513119
  516360
  516904
  517375
  518963
  521806
  523076
  523593
  525523
  525616
  526049
  526595
  533691
  534589
  539356
  540658
  543153
  551251
  552135
  554125
  555077
  566723
  572934
  573989
  575052
  588897
  597150
  599102
  608106
  614893
  617030
  660352
  666901
  709777
  719302
  730754
  803057
]
21.61 ms
(13.79%)
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
  443366
  402026
  447252
  483825
  512619
  534589
  508803
  608106
  599102
  479962
  426551
  489107
  497197
  572934
  437801
  719302
  414001
  573989
  413456
  485337
  460722
  461251
  512760
  539356
  666901
  555077
  481218
  482806
  469297
  482274
  483528
  505381
  434566
  401367
  493118
  509581
  540658
  533691
  575052
  597150
  385446
  101894
  429040
  434040
  489141
  448619
  450844
  461374
  467361
  491588
  457067
  457311
  485479
  490033
  518963
  513119
  523076
  494658
  504203
  517375
  474069
  554125
  551251
  415430
  458267
  460098
  460624
  458217
  461537
  474385
  226082
  468679
  468783
  461808
  475871
  512647
  516360
  525616
  502568
  499749
  501969
  525523
  516904
  588897
  475750
  470167
  425744
  397819
  470861
  454639
  459776
  803057
  461472
  364606
  469760
  497806
  543153
  660352
  709777
  614893
  730754
  510955
  526049
  521806
  1061
  552135
  447301
  389110
  502967
  566723
  617030
  422142
  445072
  460713
  526595
  467147
  523593
  453110
  495852
  499368
]
2.13 ms
(1.36%)
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
  1061
  101894
  226082
  364606
  385446
  389110
  397819
  401367
  402026
  413456
  414001
  415430
  422142
  425744
  426551
  429040
  434040
  434566
  437801
  443366
  445072
  447252
  447301
  448619
  450844
  453110
  454639
  457067
  457311
  458217
  458267
  459776
  460098
  460624
  460713
  460722
  461251
  461374
  461472
  461537
  461808
  467147
  467361
  468679
  468783
  469297
  469760
  470167
  470861
  474069
  474385
  475750
  475871
  479962
  481218
  482274
  482806
  483528
  483825
  485337
  485479
  489107
  489141
  490033
  491588
  493118
  494658
  495852
  497197
  497806
  499368
  499749
  501969
  502568
  502967
  504203
  505381
  508803
  509581
  510955
  512619
  512647
  512760
  513119
  516360
  516904
  517375
  518963
  521806
  523076
  523593
  525523
  525616
  526049
  526595
  533691
  534589
  539356
  540658
  543153
  551251
  552135
  554125
  555077
  566723
  572934
  573989
  575052
  588897
  597150
  599102
  608106
  614893
  617030
  660352
  666901
  709777
  719302
  730754
  803057
]
1.85 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой хуй в рот"
]
1.82 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член в рот"
]
1.57 ms
(1.00%)
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.