Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.78 ms
(82.98%)
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
  187443
  382676
  407863
  411371
  421855
  423832
  424458
  426697
  432394
  432497
  432543
  433078
  433390
  433618
  436419
  444071
  444650
  444819
  456345
  457959
  464491
  469498
  470628
  470888
  471193
  476633
  477676
  487320
  490874
  492012
  492926
  499542
  500314
  501494
  503338
  504962
  507540
  509736
  512198
  513978
  516055
  516652
  520044
  524100
  525555
  526569
  526772
  528843
  529437
  536525
  554423
  554434
  555703
  557195
  559865
  559889
  560185
  563609
  565316
  571834
  572882
  579338
  581292
  582899
  585525
  587781
  589928
  590893
  594638
  600463
  604381
  604688
  619474
  620851
  622294
  622927
  624792
  625973
  632074
  682857
  686343
  697892
  697917
  701231
  713437
  713706
  714561
  715603
  716111
  716240
  720361
  731472
  735768
  736561
  740586
  742063
  754842
  758572
  764100
  767704
  770965
  772846
  776227
  778017
  782013
  783934
  785883
  787154
  788121
  790285
  793566
  796493
  798799
  799740
  800550
  802601
  802944
  811098
  812697
]
26.11 ms
(12.26%)
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
  783934
  767704
  714561
  788121
  802944
  526772
  528843
  492012
  622927
  426697
  720361
  793566
  776227
  802601
  457959
  557195
  516652
  555703
  782013
  579338
  701231
  470628
  620851
  590893
  436419
  716111
  800550
  598922
  778017
  432394
  464491
  433390
  444071
  187443
  604381
  469498
  477676
  736561
  500314
  470888
  499542
  713706
  686343
  632074
  625973
  790285
  796493
  787154
  758572
  742063
  754842
  770965
  624792
  713437
  798799
  559865
  421855
  516055
  735768
  604688
  731472
  536525
  513978
  622294
  619474
  529437
  490874
  772846
  565316
  563609
  501494
  524100
  504962
  507540
  509736
  520044
  525555
  554434
  407863
  476633
  697917
  799740
  811098
  764100
  444819
  582899
  411371
  587781
  785883
  432497
  433618
  512198
  432543
  471193
  716240
  715603
  424458
  572882
  456345
  503338
  423832
  433078
  526569
  581292
  492926
  697892
  560185
  594638
  812697
  740586
  382676
  571834
  600463
  444650
  487320
  554423
  682857
  559889
  585525
  589928
]
3.00 ms
(1.41%)
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
  187443
  382676
  407863
  411371
  421855
  423832
  424458
  426697
  432394
  432497
  432543
  433078
  433390
  433618
  436419
  444071
  444650
  444819
  456345
  457959
  464491
  469498
  470628
  470888
  471193
  476633
  477676
  487320
  490874
  492012
  492926
  499542
  500314
  501494
  503338
  504962
  507540
  509736
  512198
  513978
  516055
  516652
  520044
  524100
  525555
  526569
  526772
  528843
  529437
  536525
  554423
  554434
  555703
  557195
  559865
  559889
  560185
  563609
  565316
  571834
  572882
  579338
  581292
  582899
  585525
  587781
  589928
  590893
  594638
  600463
  604381
  604688
  619474
  620851
  622294
  622927
  624792
  625973
  632074
  682857
  686343
  697892
  697917
  701231
  713437
  713706
  714561
  715603
  716111
  716240
  720361
  731472
  735768
  736561
  740586
  742063
  754842
  758572
  764100
  767704
  770965
  772846
  776227
  778017
  782013
  783934
  785883
  787154
  788121
  790285
  793566
  796493
  798799
  799740
  800550
  802601
  802944
  811098
  812697
]
2.02 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в трусиках и колготка%…"
]
1.83 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в трусик нижн бел колготк"
]
1.75 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.72%)
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.