Query Metrics
7
Database Queries
7
Different statements
179.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.89 ms (83.43%) |
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 334847 366296 383700 394258 395699 395924 396956 398243 400125 400179 401224 407682 418996 422194 428463 428539 428910 429528 433070 437361 437582 438429 440864 442415 443185 443711 443970 446622 451165 457191 457298 458012 458018 459783 460273 460577 460679 463691 465366 471408 476337 477987 486896 493201 493247 513784 519856 524271 524291 524652 524783 532127 534722 546425 550224 550330 550643 550644 562967 563123 563142 565012 569394 571129 582197 602707 605261 609823 622665 625649 639225 662140 685023 689002 695087 696567 699604 704174 709503 709760 711341 719912 723945 723955 724045 724456 724476 724502 725788 726390 727891 730904 743429 743431 743463 743479 743811 744563 746497 753148 753764 755695 756797 763845 769490 769503 769536 769550 772444 772446 773797 775270 788158 804329 ] |
||||||||||||||||||||||||||||||
|
19.04 ms (10.60%) |
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 724502 730904 743429 726390 769550 772444 773797 756797 639225 711341 804329 524291 395699 569394 662140 605261 775270 772446 437582 524271 383700 396956 451165 460577 550644 582197 550330 563123 695087 696567 704174 602707 755695 743463 736517 743479 746497 769530 697943 709503 443711 609823 519856 493247 395924 398243 400125 401224 407682 428539 429528 437361 442415 443185 460679 463691 465366 446622 457298 486896 458012 458018 460273 476337 493201 513784 534722 532127 524652 550643 563142 565012 709760 716936 689002 685023 550224 562967 571129 622665 788158 723955 724045 727891 724456 724476 743431 744563 769536 723945 725788 753148 769503 743811 753764 699604 719912 428463 428910 477987 394258 457191 334847 459783 440864 400179 524783 510295 546425 625649 769490 763845 697939 471408 433070 422194 366296 438429 443970 418996 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.71%) |
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 334847 366296 383700 394258 395699 395924 396956 398243 400125 400179 401224 407682 418996 422194 428463 428539 428910 429528 433070 437361 437582 438429 440864 442415 443185 443711 443970 446622 451165 457191 457298 458012 458018 459783 460273 460577 460679 463691 465366 471408 476337 477987 486896 493201 493247 513784 519856 524271 524291 524652 524783 532127 534722 546425 550224 550330 550643 550644 562967 563123 563142 565012 569394 571129 582197 602707 605261 609823 622665 625649 639225 662140 685023 689002 695087 696567 699604 704174 709503 709760 711341 719912 723945 723955 724045 724456 724476 724502 725788 726390 727891 730904 743429 743431 743463 743479 743811 744563 746497 753148 753764 755695 756797 763845 769490 769503 769536 769550 772444 772446 773797 775270 788158 804329 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom----and----son"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom son"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom son"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
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.