Query Metrics
7
Database Queries
7
Different statements
140.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.91 ms (84.50%) |
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 389729 397916 400181 401981 405978 407566 409258 421236 421822 422209 422254 422345 422352 427536 430313 434044 437497 438219 439798 443692 443722 443747 443832 449716 450181 450399 451127 451797 452977 454271 454964 458378 460659 460728 460745 461016 463624 463630 464189 464403 464963 466145 467656 467663 468091 471397 472652 473492 474776 474777 474778 474783 474788 474799 474800 476269 476341 479114 482239 482248 486533 490929 493193 495227 497104 506044 506055 506833 514390 516886 518046 518160 518856 519735 520683 521129 521264 522168 523836 523844 523902 523907 524109 524272 525469 529170 532044 532095 532114 534228 538001 538005 539744 549236 549739 549822 551923 553672 557551 557924 563151 563436 564378 565626 566928 577051 579848 584765 589682 609203 659986 679709 697909 716927 753205 769487 808675 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (9.28%) |
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 422352 464403 474776 474783 449716 450181 451797 474778 482239 518856 527201 514390 521264 524272 532044 464963 467663 472652 473492 549236 553672 557924 584765 551923 563436 676582 697909 589682 753205 769487 422345 443747 464189 471397 401981 443692 443722 450399 518046 521129 523836 523902 532114 716927 438219 427536 409258 529170 516886 522168 525469 422209 405978 421236 434044 451127 454964 458378 506833 518160 557551 659986 549739 566928 579848 609203 808675 389729 443832 460728 463624 474799 421822 460659 468091 476341 474788 466145 506055 538005 519735 490929 495227 565626 559076 564378 463630 482248 534228 563151 679709 549822 577051 460745 474777 476269 479114 400181 437497 397916 454271 422254 523907 506044 523844 493193 524109 538001 520683 439798 486533 407566 430313 467656 461016 539744 497104 532095 452977 474800 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.72%) |
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 389729 397916 400181 401981 405978 407566 409258 421236 421822 422209 422254 422345 422352 427536 430313 434044 437497 438219 439798 443692 443722 443747 443832 449716 450181 450399 451127 451797 452977 454271 454964 458378 460659 460728 460745 461016 463624 463630 464189 464403 464963 466145 467656 467663 468091 471397 472652 473492 474776 474777 474778 474783 474788 474799 474800 476269 476341 479114 482239 482248 486533 490929 493193 495227 497104 506044 506055 506833 514390 516886 518046 518160 518856 519735 520683 521129 521264 522168 523836 523844 523902 523907 524109 524272 525469 529170 532044 532095 532114 534228 538001 538005 539744 549236 549739 549822 551923 553672 557551 557924 563151 563436 564378 565626 566928 577051 579848 584765 589682 609203 659986 679709 697909 716927 753205 769487 808675 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom----and----son"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom son"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom son"
]
|
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.