Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.12 ms
(84.31%)
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
  23104
  357915
  382091
  383483
  386557
  395750
  397023
  397855
  401194
  402092
  402265
  403039
  404600
  406206
  406232
  413653
  414946
  416215
  417830
  420276
  421328
  423480
  423584
  424811
  426818
  428867
  429084
  430236
  430377
  435715
  440292
  448350
  448689
  449881
  453716
  454409
  454498
  455280
  456893
  457207
  457418
  457458
  459708
  460739
  462478
  467957
  469287
  474415
  477337
  477346
  477896
  478940
  479803
  483001
  487887
  488138
  490456
  493127
  493270
  499786
  501957
  505460
  506222
  506436
  506635
  507193
  508744
  509780
  513821
  516222
  520895
  521770
  522498
  522551
  525095
  525116
  527415
  527767
  528921
  534288
  539462
  549686
  555993
  556916
  562194
  563234
  565649
  565716
  568156
  569970
  571839
  577048
  582024
  584149
  591306
  599160
  601644
  603021
  609248
  619520
  619920
  620319
  637399
  665840
  704987
  726528
  726550
  726702
  730486
  756400
  758594
  776638
  788290
  800926
  807529
  813917
  814787
  814809
  814847
  824345
]
20.44 ms
(10.25%)
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
  813917
  582024
  403039
  509780
  788290
  406232
  601644
  619520
  453716
  704987
  423584
  488138
  357915
  493127
  416215
  457458
  814847
  479803
  477346
  549686
  477337
  499786
  637399
  402265
  448689
  462478
  824345
  584149
  665840
  516222
  603021
  23104
  406206
  555993
  726702
  477896
  426818
  599160
  513821
  756400
  758594
  423480
  525095
  455280
  609248
  483001
  522498
  807529
  490456
  460739
  507193
  383483
  457418
  420276
  726528
  440292
  401194
  456893
  539462
  527767
  776638
  395750
  397023
  726550
  404600
  814809
  521770
  506436
  474415
  386557
  397855
  568156
  424811
  402092
  421328
  382091
  565716
  730486
  478940
  620319
  459708
  591306
  449881
  619920
  563234
  413653
  417830
  571839
  577048
  527415
  506222
  525116
  505460
  469287
  454409
  430236
  435715
  562194
  414946
  448350
  565649
  454498
  506635
  508744
  520895
  501957
  429084
  428867
  556916
  800926
  467957
  534288
  814787
  569970
  430377
  457207
  522551
  528921
  487887
  493270
]
4.17 ms
(2.09%)
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
  23104
  357915
  382091
  383483
  386557
  395750
  397023
  397855
  401194
  402092
  402265
  403039
  404600
  406206
  406232
  413653
  414946
  416215
  417830
  420276
  421328
  423480
  423584
  424811
  426818
  428867
  429084
  430236
  430377
  435715
  440292
  448350
  448689
  449881
  453716
  454409
  454498
  455280
  456893
  457207
  457418
  457458
  459708
  460739
  462478
  467957
  469287
  474415
  477337
  477346
  477896
  478940
  479803
  483001
  487887
  488138
  490456
  493127
  493270
  499786
  501957
  505460
  506222
  506436
  506635
  507193
  508744
  509780
  513821
  516222
  520895
  521770
  522498
  522551
  525095
  525116
  527415
  527767
  528921
  534288
  539462
  549686
  555993
  556916
  562194
  563234
  565649
  565716
  568156
  569970
  571839
  577048
  582024
  584149
  591306
  599160
  601644
  603021
  609248
  619520
  619920
  620319
  637399
  665840
  704987
  726528
  726550
  726702
  730486
  756400
  758594
  776638
  788290
  800926
  807529
  813917
  814787
  814809
  814847
  824345
]
1.88 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother massage boy"
]
1.85 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин массаж парен"
]
1.38 ms
(0.69%)
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.