Query Metrics

8 Database Queries
8 Different statements
187.85 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
145.20 ms
(77.30%)
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
  367863
  405203
  415623
  421201
  421235
  463867
  493852
  508485
  510244
  510589
  511249
  511263
  513823
  515881
  522014
  531903
  539906
  552198
  556374
  556415
  557820
  558383
  560136
  564767
  565946
  569822
  569828
  574644
  586034
  588268
  592065
  600581
  600607
  601741
  610201
  610247
  610647
  619592
  622178
  623570
  625928
  643411
  643415
  646246
  651611
  653254
  670526
  710066
  721368
  730686
  773128
  785707
  785711
  785716
  814806
  815096
  820070
]
21.79 ms
(11.60%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "oil asian massage"
  "oil asian massage"
  "oil asian massage"
  20
]
12.18 ms
(6.48%)
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
  557820
  600607
  511263
  463867
  405203
  785716
  814806
  558383
  721368
  522014
  493852
  622178
  565946
  592065
  569828
  773128
  610201
  623570
  730686
  653254
  785707
  415623
  531903
  552198
  569822
  588268
  574644
  710066
  508485
  610247
  367863
  556374
  643415
  515881
  510589
  785711
  421235
  820070
  646246
  651611
  601741
  610647
  560136
  511249
  600581
  564767
  619592
  670526
  510244
  513823
  643411
  586034
  815096
  556415
  625928
  539906
  421201
]
2.90 ms
(1.54%)
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
  367863
  405203
  415623
  421201
  421235
  463867
  493852
  508485
  510244
  510589
  511249
  511263
  513823
  515881
  522014
  531903
  539906
  552198
  556374
  556415
  557820
  558383
  560136
  564767
  565946
  569822
  569828
  574644
  586034
  588268
  592065
  600581
  600607
  601741
  610201
  610247
  610647
  619592
  622178
  623570
  625928
  643411
  643415
  646246
  651611
  653254
  670526
  710066
  721368
  730686
  773128
  785707
  785711
  785716
  814806
  815096
  820070
]
1.63 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "масл азиатк массаж"
]
1.50 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "oil asian massage"
]
1.34 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "масл азиатк массаж"
]
1.32 ms
(0.70%)
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.