Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.25 ms
(82.80%)
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
  382355
  417830
  419101
  427173
  439588
  447504
  451141
  451247
  451816
  454442
  456703
  457186
  465345
  466350
  469580
  470449
  472493
  472569
  475870
  487633
  494312
  494487
  496674
  500758
  505806
  507865
  511793
  512574
  513699
  513705
  516651
  522235
  525204
  525760
  527377
  528699
  535426
  538498
  540252
  549769
  552971
  553720
  556326
  565313
  566862
  570764
  575932
  580229
  582920
  587047
  588661
  589661
  589696
  589703
  592095
  593018
  621729
  624456
  625873
  625893
  633468
  639102
  641624
  648370
  666583
  682273
  691820
  696969
  712475
  712675
  714147
  726475
  726478
  726484
  726505
  726513
  726528
  726529
  726534
  726552
  726673
  726688
  726699
  726713
  729930
  729950
  730986
  737188
  740101
  741190
  742860
  746162
  747591
  753138
  755030
  755522
  756703
  757502
  759738
  766869
  769160
  782259
  785096
  789002
  790795
  795757
  796088
  796109
  803106
  805179
  806884
  810864
  810906
  810967
  811963
  812361
  814210
  814501
  817917
  825054
]
16.79 ms
(10.35%)
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
  753138
  427173
  825054
  580229
  666583
  746162
  759738
  756703
  740101
  538498
  624456
  729930
  696969
  714147
  588661
  639102
  790795
  810906
  726534
  747591
  755522
  769160
  796088
  806884
  810864
  726484
  726552
  726529
  730986
  742860
  757502
  782259
  803106
  419101
  712475
  726513
  766869
  456703
  447504
  535426
  648370
  691820
  755030
  417830
  810967
  811963
  729950
  814501
  814210
  817917
  451247
  457186
  487633
  511793
  540252
  556326
  682273
  712675
  575932
  625893
  795757
  796109
  726505
  726688
  726478
  737188
  741190
  466350
  512574
  513699
  505806
  472569
  507865
  726475
  785096
  472493
  525204
  587047
  451141
  454442
  552971
  570764
  582920
  589703
  641624
  592095
  805179
  726713
  475870
  513705
  522235
  525760
  469580
  549769
  494487
  516651
  527377
  528699
  593018
  633468
  500758
  565313
  589696
  726528
  726699
  726673
  621729
  789002
  382355
  439588
  451816
  470449
  496674
  566862
  812361
  494312
  465345
  553720
  589661
  625873
]
3.31 ms
(2.04%)
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
  382355
  417830
  419101
  427173
  439588
  447504
  451141
  451247
  451816
  454442
  456703
  457186
  465345
  466350
  469580
  470449
  472493
  472569
  475870
  487633
  494312
  494487
  496674
  500758
  505806
  507865
  511793
  512574
  513699
  513705
  516651
  522235
  525204
  525760
  527377
  528699
  535426
  538498
  540252
  549769
  552971
  553720
  556326
  565313
  566862
  570764
  575932
  580229
  582920
  587047
  588661
  589661
  589696
  589703
  592095
  593018
  621729
  624456
  625873
  625893
  633468
  639102
  641624
  648370
  666583
  682273
  691820
  696969
  712475
  712675
  714147
  726475
  726478
  726484
  726505
  726513
  726528
  726529
  726534
  726552
  726673
  726688
  726699
  726713
  729930
  729950
  730986
  737188
  740101
  741190
  742860
  746162
  747591
  753138
  755030
  755522
  756703
  757502
  759738
  766869
  769160
  782259
  785096
  789002
  790795
  795757
  796088
  796109
  803106
  805179
  806884
  810864
  810906
  810967
  811963
  812361
  814210
  814501
  817917
  825054
]
2.15 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "delicious of ass"
]
2.05 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "delicious жоп"
]
1.78 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "delicious жоп"
]

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.