Query Metrics
7
Database Queries
7
Different statements
173.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.72 ms (82.96%) |
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 384518 392404 395597 395869 396230 398317 400669 400957 401177 413968 419607 428184 432118 437668 443883 444058 451595 455585 458538 459072 461438 463895 463897 465987 468691 469854 470045 472767 473417 473940 474601 475059 475451 479009 479759 480960 482626 482699 484274 488551 492109 493039 493194 495070 499103 501649 501831 505453 510672 511239 512495 514999 516922 517106 517663 518125 518446 519187 519500 519565 521430 521588 529054 538207 538773 545670 548701 552566 554290 557086 558044 561710 561840 565158 565440 566347 566621 568460 575430 576271 577333 578501 581168 585160 592358 592490 597552 597951 602268 607093 621287 626880 634161 649133 652869 677726 679373 680183 686091 692117 695463 698012 714018 717877 720197 721367 741249 753480 761740 768347 769767 770319 771763 781326 790925 794331 799342 800545 814250 827835 ] |
||||||||||||||||||||||||||||||
|
19.44 ms (11.22%) |
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 521430 443883 495070 419607 514999 488551 511239 516922 492109 505453 519565 652869 428184 396230 548701 677726 597552 799342 790925 395597 475451 475059 558044 565158 557086 545670 679373 554290 575430 592358 395869 469854 473940 400669 459072 480960 437668 470045 474601 392404 463895 463897 501831 517106 501649 517663 518446 519500 398317 519187 472767 451595 626880 814250 565440 692117 800545 741249 384518 827835 770319 769767 400957 720197 686091 753480 714018 717877 695463 781326 768347 761740 794331 602268 698012 649133 621287 721367 566621 581168 512495 521588 493194 499103 529054 592490 771763 538207 518125 680183 413968 432118 482699 482626 458538 455585 468691 538773 552566 561840 576271 577333 566347 568460 561710 578501 597951 585160 634161 607093 444058 461438 465987 479759 401177 473417 479009 484274 493039 510672 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.66%) |
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 384518 392404 395597 395869 396230 398317 400669 400957 401177 413968 419607 428184 432118 437668 443883 444058 451595 455585 458538 459072 461438 463895 463897 465987 468691 469854 470045 472767 473417 473940 474601 475059 475451 479009 479759 480960 482626 482699 484274 488551 492109 493039 493194 495070 499103 501649 501831 505453 510672 511239 512495 514999 516922 517106 517663 518125 518446 519187 519500 519565 521430 521588 529054 538207 538773 545670 548701 552566 554290 557086 558044 561710 561840 565158 565440 566347 566621 568460 575430 576271 577333 578501 581168 585160 592358 592490 597552 597951 602268 607093 621287 626880 634161 649133 652869 677726 679373 680183 686091 692117 695463 698012 714018 717877 720197 721367 741249 753480 761740 768347 769767 770319 771763 781326 790925 794331 799342 800545 814250 827835 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал красивая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal beautiful girl"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.