Query Metrics
7
Database Queries
7
Different statements
186.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.04 ms (84.83%) |
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 75664 386735 398681 411471 417095 419277 423531 423548 424350 432690 432710 432737 434549 437610 437965 442524 444326 446845 446921 448089 449545 450914 452731 452770 453025 455467 455494 455509 458061 458323 461323 462613 463634 468283 468404 472546 479568 481392 481403 481757 486614 487359 490417 495281 496123 497201 498666 499950 501543 502082 509325 511505 514330 514447 521002 530458 540805 541068 542540 545568 556104 557735 562462 563633 563892 571126 579856 582077 591832 610322 612752 617512 620195 623961 623972 626324 626452 630664 631607 636242 652007 654919 674907 676421 684695 690050 694953 700724 707440 726621 730359 730813 736257 737274 740869 742640 744061 746171 749150 756245 759673 760064 761137 764165 764200 765322 766707 791201 792316 793820 796106 797392 802150 803580 804552 805259 813482 814435 818072 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (9.56%) |
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 620195 636242 591832 617512 792316 793820 796106 802150 791201 740869 813482 730813 736257 742640 764165 759673 797392 423548 499950 432710 814435 449545 486614 495281 502082 490417 541068 545568 674907 707440 654919 684695 690050 694953 700724 676421 610322 623961 626324 804552 756245 766707 726621 760064 764200 765322 737274 744061 746171 626452 424350 455509 386735 434549 450914 75664 419277 446845 452770 462613 472546 448089 481392 481757 514447 514330 497201 423531 444326 432690 818072 458323 487359 455467 446921 452731 461323 481403 498666 530458 468283 542540 556104 579856 571126 582077 563892 652007 557735 562462 563633 626851 631607 612752 623972 803580 805259 730359 749150 761137 630664 453025 458061 479568 411471 437965 398681 455494 463634 468404 509325 501543 496123 511505 521002 432737 437610 442524 417095 540805 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.55%) |
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 75664 386735 398681 411471 417095 419277 423531 423548 424350 432690 432710 432737 434549 437610 437965 442524 444326 446845 446921 448089 449545 450914 452731 452770 453025 455467 455494 455509 458061 458323 461323 462613 463634 468283 468404 472546 479568 481392 481403 481757 486614 487359 490417 495281 496123 497201 498666 499950 501543 502082 509325 511505 514330 514447 521002 530458 540805 541068 542540 545568 556104 557735 562462 563633 563892 571126 579856 582077 591832 610322 612752 617512 620195 623961 623972 626324 626452 630664 631607 636242 652007 654919 674907 676421 684695 690050 694953 700724 707440 726621 730359 730813 736257 737274 740869 742640 744061 746171 749150 756245 759673 760064 761137 764165 764200 765322 766707 791201 792316 793820 796106 797392 802150 803580 804552 805259 813482 814435 818072 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"inside creampie"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"inside creampie"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"inside creampie"
]
|
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.