Query Metrics
7
Database Queries
7
Different statements
145.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.97 ms (82.01%) |
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 385427 385818 390382 394338 396952 400185 400808 407111 416857 422155 422200 422484 428858 437670 439768 440614 440693 441003 442118 442377 442523 442869 442978 443278 443711 443935 445056 446284 454048 454188 454423 455215 457435 459254 460197 460577 465367 466133 471046 474097 476250 476276 479040 484775 485462 489381 489382 489384 489960 490929 493174 493175 493189 493195 493222 493224 493225 495007 495222 495223 495225 495227 495394 500796 502809 502813 505822 505826 505956 506824 517518 518159 518944 520892 520916 521133 523827 523830 523837 523848 523905 524286 524486 526449 531934 532060 532131 532689 538002 538010 547607 549821 550219 550642 550644 563151 563438 563447 563450 564173 568344 589681 620265 660070 671862 717689 720602 724706 731070 731129 736393 742751 781824 795234 800743 810472 810771 813918 813920 823803 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (11.70%) |
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 538002 489384 493174 493189 493225 495007 495223 500796 502813 505956 521133 523848 489381 490929 493175 493195 495222 495225 495227 502809 506824 520916 523827 523837 524486 538010 457435 620265 589681 422200 439768 440614 440693 400808 465367 442377 442523 443278 479040 523830 489382 493224 385427 394338 396952 437670 442978 422484 813920 813918 823803 454048 455215 489960 517518 520892 531934 518944 523905 524286 526449 532131 495394 532060 460577 550644 550642 660070 671862 717689 781824 795234 800743 731070 810472 810771 724706 742751 736393 731129 720602 428858 446284 476276 443711 459254 385818 445056 485462 493222 563450 390382 422155 441003 442118 454188 442869 466133 471046 400185 407111 416857 443935 474097 454423 505826 518159 505822 532689 460197 476250 484775 549821 563151 563438 563447 547607 550219 564173 568344 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.46%) |
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 385427 385818 390382 394338 396952 400185 400808 407111 416857 422155 422200 422484 428858 437670 439768 440614 440693 441003 442118 442377 442523 442869 442978 443278 443711 443935 445056 446284 454048 454188 454423 455215 457435 459254 460197 460577 465367 466133 471046 474097 476250 476276 479040 484775 485462 489381 489382 489384 489960 490929 493174 493175 493189 493195 493222 493224 493225 495007 495222 495223 495225 495227 495394 500796 502809 502813 505822 505826 505956 506824 517518 518159 518944 520892 520916 521133 523827 523830 523837 523848 523905 524286 524486 526449 531934 532060 532131 532689 538002 538010 547607 549821 550219 550642 550644 563151 563438 563447 563450 564173 568344 589681 620265 660070 671862 717689 720602 724706 731070 731129 736393 742751 781824 795234 800743 810472 810771 813918 813920 823803 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son and mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son mature"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son mature"
]
|
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.