Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.06 ms
(84.46%)
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
  392588
  419543
  420008
  423856
  432595
  437440
  437599
  437765
  442913
  443348
  447204
  454163
  460585
  466254
  470621
  477131
  481451
  485366
  487405
  488500
  491052
  513701
  515592
  516941
  519359
  522927
  528814
  542347
  544615
  545498
  546720
  547734
  547758
  547761
  547767
  553972
  556010
  568716
  569995
  571508
  573468
  585086
  594873
  597047
  598742
  599353
  600087
  611766
  644016
  649516
  655545
  669868
  683301
  699708
  704892
  705531
  714763
  715072
  720830
  724871
  728660
  733540
  734459
  741194
  742317
  744860
  751508
  751534
  751553
  751597
  751606
  751615
  755140
  757135
  757695
  758215
  758287
  758325
  761127
  763746
  763874
  765817
  765860
  766166
  767639
  767759
  773474
  773475
  777570
  779369
  779424
  779475
  783392
  783402
  784235
  784569
  785972
  786977
  790691
  799870
  800657
  800682
  801296
  802029
  802555
  805148
  809504
  816695
  817510
  819711
  819779
  819919
  820178
  823272
  824299
  825327
  825870
  826571
]
13.57 ms
(9.17%)
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
  454163
  460585
  817510
  585086
  826571
  553972
  547734
  547758
  683301
  649516
  720830
  545498
  556010
  573468
  600087
  785972
  801296
  783392
  784569
  765860
  751615
  773474
  773475
  758325
  761127
  765817
  783402
  802029
  809504
  481451
  491052
  528814
  487405
  704892
  779424
  757135
  744860
  777570
  820178
  825870
  824299
  819779
  819919
  816695
  823272
  819711
  825327
  542347
  544615
  547761
  655545
  714763
  669868
  568716
  611766
  594873
  598742
  597047
  644016
  779369
  779475
  800657
  805148
  741194
  742317
  758287
  784235
  790691
  799870
  733540
  759378
  763874
  767759
  724871
  751606
  758215
  766166
  734459
  751534
  757695
  763746
  767639
  728660
  751508
  751553
  755140
  763722
  699708
  705531
  715072
  786977
  800682
  802555
  443348
  470621
  419543
  569995
  571508
  423856
  437599
  477131
  442913
  437765
  751597
  599353
  392588
  432595
  466254
  547767
  513701
  519359
  546720
  437440
  447204
  420008
  515592
  516941
  522927
  488500
  485366
]
2.37 ms
(1.60%)
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
  392588
  419543
  420008
  423856
  432595
  437440
  437599
  437765
  442913
  443348
  447204
  454163
  460585
  466254
  470621
  477131
  481451
  485366
  487405
  488500
  491052
  513701
  515592
  516941
  519359
  522927
  528814
  542347
  544615
  545498
  546720
  547734
  547758
  547761
  547767
  553972
  556010
  568716
  569995
  571508
  573468
  585086
  594873
  597047
  598742
  599353
  600087
  611766
  644016
  649516
  655545
  669868
  683301
  699708
  704892
  705531
  714763
  715072
  720830
  724871
  728660
  733540
  734459
  741194
  742317
  744860
  751508
  751534
  751553
  751597
  751606
  751615
  755140
  757135
  757695
  758215
  758287
  758325
  761127
  763746
  763874
  765817
  765860
  766166
  767639
  767759
  773474
  773475
  777570
  779369
  779424
  779475
  783392
  783402
  784235
  784569
  785972
  786977
  790691
  799870
  800657
  800682
  801296
  802029
  802555
  805148
  809504
  816695
  817510
  819711
  819779
  819919
  820178
  823272
  824299
  825327
  825870
  826571
]
1.93 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск милф мам женщин"
]
1.81 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские милфы мамы"
]
1.68 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск милф мам женщин"
]
1.63 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.