Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
377.62 ms
(93.17%)
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
  56464
  107545
  153472
  161969
  193837
  338258
  338311
  366354
  382802
  384778
  386879
  387195
  389730
  390574
  391054
  391163
  392028
  394785
  395148
  395522
  398946
  406579
  407683
  409887
  423771
  424910
  425630
  440979
  448671
  451456
  460190
  464240
  465434
  468183
  468750
  471627
  471963
  475629
  484063
  492001
  493170
  496607
  496625
  531066
  534454
  540351
  540691
  543288
  553841
  563445
  575177
  577138
  579163
  580270
  589687
  591279
  591283
  597604
  601925
  606640
  616679
  618344
  618960
  621716
  624691
  627052
  632929
  633050
  643097
  649919
  658468
  664285
  665478
  669747
  676121
  682181
  687555
  702237
  703141
  706007
  712335
  715459
  717948
  721674
  725355
  725826
  726538
  730225
  734572
  734903
  741859
  744922
  744968
  746000
  749861
  754680
  755087
  755140
  755322
  756452
  758185
  759484
  759975
  764456
  770061
  774141
  775800
  784776
  790238
  790640
  795147
  795835
  796278
  796759
  797355
  800684
  801344
  803437
  809941
  810062
]
17.76 ms
(4.38%)
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
  161969
  801344
  56464
  721674
  649919
  591279
  643097
  597604
  790238
  755087
  755322
  754680
  774141
  391054
  759975
  338311
  715459
  758185
  734572
  484063
  665478
  746000
  627052
  712335
  725355
  759484
  730225
  800684
  755140
  632929
  797355
  810062
  703141
  394785
  618960
  775800
  471963
  795147
  386879
  543288
  601925
  741859
  749861
  440979
  409887
  392028
  389730
  664285
  382802
  107545
  424910
  496625
  658468
  764456
  770061
  540351
  553841
  744922
  624691
  460190
  395148
  425630
  563445
  717948
  579163
  423771
  384778
  398946
  391163
  621716
  702237
  616679
  338258
  451456
  580270
  496607
  468183
  193837
  465434
  540691
  534454
  687555
  669747
  606640
  796759
  803437
  756452
  725826
  809941
  448671
  790640
  706007
  633050
  796278
  795835
  734903
  575177
  618344
  744968
  407683
  366354
  390574
  475629
  464240
  387195
  406579
  493170
  531066
  153472
  676121
  577138
  589687
  591283
  682181
  395522
  468750
  784776
  726538
  471627
  492001
]
3.09 ms
(0.76%)
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
  56464
  107545
  153472
  161969
  193837
  338258
  338311
  366354
  382802
  384778
  386879
  387195
  389730
  390574
  391054
  391163
  392028
  394785
  395148
  395522
  398946
  406579
  407683
  409887
  423771
  424910
  425630
  440979
  448671
  451456
  460190
  464240
  465434
  468183
  468750
  471627
  471963
  475629
  484063
  492001
  493170
  496607
  496625
  531066
  534454
  540351
  540691
  543288
  553841
  563445
  575177
  577138
  579163
  580270
  589687
  591279
  591283
  597604
  601925
  606640
  616679
  618344
  618960
  621716
  624691
  627052
  632929
  633050
  643097
  649919
  658468
  664285
  665478
  669747
  676121
  682181
  687555
  702237
  703141
  706007
  712335
  715459
  717948
  721674
  725355
  725826
  726538
  730225
  734572
  734903
  741859
  744922
  744968
  746000
  749861
  754680
  755087
  755140
  755322
  756452
  758185
  759484
  759975
  764456
  770061
  774141
  775800
  784776
  790238
  790640
  795147
  795835
  796278
  796759
  797355
  800684
  801344
  803437
  809941
  810062
]
1.91 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамка соблазняет"
]
1.73 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин соблазня"
]
1.61 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.38%)
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.