Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.20 ms
(84.40%)
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
  397438
  399857
  411804
  414433
  415452
  419710
  421537
  423568
  431963
  440958
  443467
  449760
  452762
  454633
  454883
  459128
  460600
  461729
  462908
  466727
  467023
  468706
  468957
  470037
  471631
  474061
  474725
  474756
  475951
  482098
  482780
  485998
  486396
  486474
  487583
  491457
  491674
  492389
  492576
  494081
  495214
  497007
  498105
  501242
  504057
  506772
  508275
  510433
  510498
  516004
  516015
  519694
  520710
  522125
  522374
  522839
  526842
  527229
  528761
  529257
  544480
  544852
  550416
  550853
  553037
  556015
  559155
  560669
  561671
  568720
  569385
  571964
  573732
  575423
  576103
  582376
  584168
  584516
  585838
  587797
  588654
  589357
  589450
  590696
  591397
  591670
  591792
  592332
  592839
  593354
  593641
  594406
  596786
  598263
  598642
  600030
  600485
  600586
  601101
  601677
  601856
  603011
  604560
  606202
  610586
  613463
  615826
  615829
  618645
  618672
  620268
  621663
  623681
  623817
  624282
  626136
  677357
  721538
  736101
  777674
]
18.53 ms
(10.08%)
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
  431963
  592332
  468957
  468706
  575423
  585838
  589357
  593354
  736101
  498105
  598263
  494081
  486474
  504057
  544480
  623681
  522374
  544852
  569385
  571964
  587797
  591397
  592839
  588654
  600485
  618645
  618672
  449760
  560669
  591792
  606202
  411804
  443467
  460600
  482780
  528761
  474725
  553037
  591670
  624282
  604560
  415452
  419710
  454633
  454883
  474756
  482098
  519694
  526842
  529257
  506772
  594406
  459128
  487583
  621663
  510433
  508275
  516015
  510498
  461729
  520710
  397438
  550853
  470037
  584516
  615826
  589450
  559155
  610586
  497007
  516004
  721538
  590696
  495214
  601101
  582376
  626136
  613463
  485998
  573732
  620268
  399857
  475951
  440958
  615829
  466727
  421537
  452762
  471631
  414433
  491674
  462908
  492389
  556015
  677357
  522839
  486396
  492576
  603011
  596786
  568720
  501242
  423568
  777674
  623817
  522125
  527229
  550416
  600586
  598642
  474061
  491457
  600030
  601677
  601856
  584168
  576103
  593641
  467023
  561671
]
3.53 ms
(1.92%)
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
  397438
  399857
  411804
  414433
  415452
  419710
  421537
  423568
  431963
  440958
  443467
  449760
  452762
  454633
  454883
  459128
  460600
  461729
  462908
  466727
  467023
  468706
  468957
  470037
  471631
  474061
  474725
  474756
  475951
  482098
  482780
  485998
  486396
  486474
  487583
  491457
  491674
  492389
  492576
  494081
  495214
  497007
  498105
  501242
  504057
  506772
  508275
  510433
  510498
  516004
  516015
  519694
  520710
  522125
  522374
  522839
  526842
  527229
  528761
  529257
  544480
  544852
  550416
  550853
  553037
  556015
  559155
  560669
  561671
  568720
  569385
  571964
  573732
  575423
  576103
  582376
  584168
  584516
  585838
  587797
  588654
  589357
  589450
  590696
  591397
  591670
  591792
  592332
  592839
  593354
  593641
  594406
  596786
  598263
  598642
  600030
  600485
  600586
  601101
  601677
  601856
  603011
  604560
  606202
  610586
  613463
  615826
  615829
  618645
  618672
  620268
  621663
  623681
  623817
  624282
  626136
  677357
  721538
  736101
  777674
]
1.82 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur ass casting"
]
1.67 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск жоп кастинг"
]
1.64 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск жоп кастинг"
]
1.49 ms
(0.81%)
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.