Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.93 ms
(81.95%)
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
  120415
  383523
  387973
  394664
  395233
  399414
  400080
  400272
  401998
  415205
  417136
  418403
  418524
  419429
  419571
  424932
  429086
  429097
  429179
  429312
  429313
  429629
  429630
  429754
  438763
  438857
  441048
  445616
  446166
  446333
  446531
  446873
  447357
  447631
  449267
  449302
  449687
  456638
  458612
  464281
  465991
  467351
  468791
  472952
  473103
  474383
  474814
  477544
  479330
  481008
  481494
  482081
  482090
  482621
  482725
  484009
  484134
  488152
  489486
  489607
  489616
  489630
  494487
  495820
  497096
  498518
  499143
  500425
  501452
  505103
  508914
  510565
  512074
  515178
  515785
  519012
  520505
  523066
  525019
  525251
  542681
  543514
  543720
  548034
  552745
  560508
  560663
  564132
  564473
  565054
  570718
  571812
  575905
  578409
  580706
  584633
  585142
  585173
  586692
  592062
  594503
  612844
  614605
  629151
  637520
  652913
  664558
  671296
  673128
  676776
  712803
  714494
  730875
  731484
  740920
  747687
  789013
  808909
  814137
  814506
]
16.81 ms
(11.12%)
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
  429313
  473103
  418403
  429179
  449687
  467351
  465991
  481494
  494487
  498518
  523066
  484009
  484134
  489607
  488152
  489616
  489630
  508914
  383523
  120415
  429754
  441048
  438857
  814137
  446333
  447357
  468791
  520505
  512074
  472952
  474814
  542681
  584633
  565054
  570718
  543514
  652913
  712803
  676776
  671296
  592062
  586692
  789013
  808909
  730875
  731484
  400272
  418524
  438763
  449267
  449302
  481008
  429630
  445616
  525251
  515785
  501452
  482090
  614605
  424932
  458612
  446873
  500425
  664558
  673128
  629151
  387973
  429097
  543720
  637520
  456638
  399414
  400080
  429086
  446166
  505103
  515178
  464281
  575905
  578409
  580706
  714494
  564132
  612844
  747687
  401998
  429312
  474383
  395233
  482621
  447631
  499143
  571812
  560663
  594503
  585173
  740920
  446531
  482081
  394664
  415205
  417136
  479330
  429629
  477544
  525019
  489486
  519012
  495820
  497096
  419429
  419571
  814506
  585142
  482725
  510565
  548034
  560508
  564473
  552745
]
3.48 ms
(2.30%)
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
  120415
  383523
  387973
  394664
  395233
  399414
  400080
  400272
  401998
  415205
  417136
  418403
  418524
  419429
  419571
  424932
  429086
  429097
  429179
  429312
  429313
  429629
  429630
  429754
  438763
  438857
  441048
  445616
  446166
  446333
  446531
  446873
  447357
  447631
  449267
  449302
  449687
  456638
  458612
  464281
  465991
  467351
  468791
  472952
  473103
  474383
  474814
  477544
  479330
  481008
  481494
  482081
  482090
  482621
  482725
  484009
  484134
  488152
  489486
  489607
  489616
  489630
  494487
  495820
  497096
  498518
  499143
  500425
  501452
  505103
  508914
  510565
  512074
  515178
  515785
  519012
  520505
  523066
  525019
  525251
  542681
  543514
  543720
  548034
  552745
  560508
  560663
  564132
  564473
  565054
  570718
  571812
  575905
  578409
  580706
  584633
  585142
  585173
  586692
  592062
  594503
  612844
  614605
  629151
  637520
  652913
  664558
  671296
  673128
  676776
  712803
  714494
  730875
  731484
  740920
  747687
  789013
  808909
  814137
  814506
]
1.96 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "petite 18 skinny"
]
1.57 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "petite 18 худые"
]
1.51 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "petite 18 худые"
]

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.