Query Metrics
8
Database Queries
8
Different statements
178.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.30 ms (81.60%) |
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 81869 387347 390467 390918 405128 417095 418610 420749 423384 424655 427620 433413 447594 451292 452497 456493 458996 460586 461757 464697 465411 467755 467796 473673 473683 474449 476111 476971 483030 485796 486374 487748 494223 495516 499092 503009 508166 510995 524623 529137 532339 543397 543846 545176 550678 552255 557071 558775 558947 558998 581721 595314 605871 610125 610154 613868 615386 616888 617592 621055 621109 629647 648599 648630 651544 656672 663298 670197 672876 688532 693782 697327 697690 706215 707629 710390 716383 716497 720407 724415 726348 729223 731442 731825 734037 735578 737320 740508 740577 747571 750792 753023 756622 758919 759135 761517 763604 768959 770749 773963 775513 776270 777567 781065 785395 786570 787221 787760 788342 789936 793836 793844 794399 803208 805273 808050 808371 809749 817416 817711 ] |
||||||||||||||||||||||||||||||
|
19.69 ms (11.06%) |
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 809749 726348 750792 756622 729223 758919 724415 710390 716497 494223 390918 456493 510995 543846 543397 794399 427620 499092 581721 465411 524623 557071 793844 735578 474449 476111 464697 420749 545176 558947 651544 558775 613868 763604 817711 487748 447594 495516 663298 693782 697690 720407 672876 706215 688532 550678 616888 775513 777567 808050 781065 786570 734037 737320 787221 787760 768959 770749 789936 805273 81869 656672 621109 793836 776270 390467 817416 483030 532339 648599 697327 707629 648630 615386 595314 617592 731825 740508 747571 740577 467796 418610 460586 605871 785395 808371 387347 405128 458996 558998 552255 508166 452497 670197 621055 759135 473683 503009 486374 803208 753023 761517 773963 424655 423384 451292 461757 476971 610125 629647 610154 788342 433413 529137 485796 473673 467755 716383 417095 731442 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.69%) |
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 81869 387347 390467 390918 405128 417095 418610 420749 423384 424655 427620 433413 447594 451292 452497 456493 458996 460586 461757 464697 465411 467755 467796 473673 473683 474449 476111 476971 483030 485796 486374 487748 494223 495516 499092 503009 508166 510995 524623 529137 532339 543397 543846 545176 550678 552255 557071 558775 558947 558998 581721 595314 605871 610125 610154 613868 615386 616888 617592 621055 621109 629647 648599 648630 651544 656672 663298 670197 672876 688532 693782 697327 697690 706215 707629 710390 716383 716497 720407 724415 726348 729223 731442 731825 734037 735578 737320 740508 740577 747571 750792 753023 756622 758919 759135 761517 763604 768959 770749 773963 775513 776270 777567 781065 785395 786570 787221 787760 788342 789936 793836 793844 794399 803208 805273 808050 808371 809749 817416 817711 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits cumshot"
]
|
||||||||||||||||||||||||||||||
|
2.23 ms (1.25%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01““:È“qãª3ÀåyÒnL"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.98%) |
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.