Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.62 ms
(81.56%)
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
  142493
  154157
  187717
  191254
  306089
  310679
  358264
  389726
  389966
  398553
  399738
  402131
  404028
  411362
  411547
  424013
  429895
  432582
  439528
  439542
  440440
  444684
  448404
  460069
  460226
  465385
  466049
  466206
  466209
  466256
  470191
  470949
  485275
  487880
  488402
  490414
  491636
  493535
  503845
  515977
  517711
  518594
  521130
  521210
  530011
  531699
  534959
  547764
  547862
  558441
  561386
  567338
  573801
  579876
  581251
  584353
  586931
  591042
  592462
  593342
  596872
  598169
  599153
  604823
  606202
  609229
  619544
  620157
  623978
  643542
  668597
  670947
  671749
  678767
  703540
  716903
  717007
  720719
  721700
  725180
  729700
  736776
  737726
  739668
  748478
  752134
  756685
  758304
  758701
  760998
  761469
  761784
  766693
  766872
  777031
  787637
  790229
  790840
  791626
  794941
  796062
  796092
  799077
  800616
  800800
  806078
  811681
  813005
  815184
  815320
  816067
  817556
  817613
  819411
  823151
  824182
  826157
  826166
  828535
  828873
]
16.34 ms
(10.96%)
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
  439528
  389726
  717007
  736776
  756685
  191254
  440440
  596872
  399738
  599153
  488402
  817556
  824182
  826166
  819411
  826157
  828873
  521210
  531699
  668597
  547862
  593342
  777031
  800800
  790840
  800616
  758701
  758304
  725180
  402131
  398553
  515977
  558441
  154157
  310679
  790229
  739668
  796062
  760998
  752134
  465385
  517711
  503845
  485275
  389966
  187717
  591042
  460226
  606202
  620157
  547764
  567338
  670947
  598169
  623978
  787637
  806078
  811681
  737726
  466256
  466209
  466049
  521130
  444684
  609229
  142493
  404028
  448404
  432582
  823151
  487880
  604823
  643542
  748478
  766872
  766693
  791626
  799077
  813005
  761784
  796092
  761469
  470949
  518594
  429895
  721700
  358264
  817613
  828535
  581251
  794941
  729700
  411547
  579876
  460069
  424013
  561386
  678767
  470191
  466206
  573801
  439542
  411362
  490414
  491636
  530011
  619544
  493535
  306089
  816067
  815320
  815184
  534959
  584353
  671749
  716903
  720719
  703540
  586931
  592462
]
3.22 ms
(2.16%)
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
  142493
  154157
  187717
  191254
  306089
  310679
  358264
  389726
  389966
  398553
  399738
  402131
  404028
  411362
  411547
  424013
  429895
  432582
  439528
  439542
  440440
  444684
  448404
  460069
  460226
  465385
  466049
  466206
  466209
  466256
  470191
  470949
  485275
  487880
  488402
  490414
  491636
  493535
  503845
  515977
  517711
  518594
  521130
  521210
  530011
  531699
  534959
  547764
  547862
  558441
  561386
  567338
  573801
  579876
  581251
  584353
  586931
  591042
  592462
  593342
  596872
  598169
  599153
  604823
  606202
  609229
  619544
  620157
  623978
  643542
  668597
  670947
  671749
  678767
  703540
  716903
  717007
  720719
  721700
  725180
  729700
  736776
  737726
  739668
  748478
  752134
  756685
  758304
  758701
  760998
  761469
  761784
  766693
  766872
  777031
  787637
  790229
  790840
  791626
  794941
  796062
  796092
  799077
  800616
  800800
  806078
  811681
  813005
  815184
  815320
  816067
  817556
  817613
  819411
  823151
  824182
  826157
  826166
  828535
  828873
]
2.30 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в анал в чулках мамки"
]
2.06 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал чулк нижн бел мам женщин"
]
1.82 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.17%)
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.