Query Metrics
7
Database Queries
7
Different statements
376.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.98 ms (55.79%) |
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 400151 416377 417497 422078 429342 431442 445728 447079 450421 455211 455653 460824 467882 470339 472414 472751 473226 479256 482039 482125 482870 482997 483952 484127 485116 485537 488551 489548 490324 491409 492718 493851 494780 495399 495679 496088 496611 498621 503105 503131 503619 505113 505461 508140 509324 510200 511011 511446 511496 511508 515097 516425 519510 522905 523752 524015 524736 526955 534032 536154 541051 546414 548908 551091 553097 555850 555853 556563 557432 559521 560583 564010 564593 564962 566217 566342 567777 571511 573296 575104 575151 575841 576030 578410 579628 581401 583444 584421 584566 586426 586695 587211 587397 591385 592402 592643 598184 599963 600344 601427 601978 605794 611032 612607 616396 619221 621647 621814 624000 625934 626008 630500 645276 674507 691335 692859 696450 714109 762159 795683 ] |
||||||||||||||||||||||||||||||
|
141.37 ms (37.56%) |
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 400151 416377 417497 422078 429342 431442 445728 447079 450421 455211 455653 460824 467882 470339 472414 472751 473226 479256 482039 482125 482870 482997 483952 484127 485116 485537 488551 489548 490324 491409 492718 493851 494780 495399 495679 496088 496611 498621 503105 503131 503619 505113 505461 508140 509324 510200 511011 511446 511496 511508 515097 516425 519510 522905 523752 524015 524736 526955 534032 536154 541051 546414 548908 551091 553097 555850 555853 556563 557432 559521 560583 564010 564593 564962 566217 566342 567777 571511 573296 575104 575151 575841 576030 578410 579628 581401 583444 584421 584566 586426 586695 587211 587397 591385 592402 592643 598184 599963 600344 601427 601978 605794 611032 612607 616396 619221 621647 621814 624000 625934 626008 630500 645276 674507 691335 692859 696450 714109 762159 795683 ] |
||||||||||||||||||||||||||||||
|
17.95 ms (4.77%) |
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 496611 503131 511011 534032 505461 526955 511446 536154 505113 472414 473226 555853 556563 564962 571511 583444 546414 557432 566342 548908 553097 564010 573296 575104 579628 674507 692859 691335 559521 586426 592402 592643 626008 600344 601978 616396 619221 586695 587211 601427 621814 762159 416377 472751 482125 422078 450421 482039 429342 479256 455211 455653 508140 515097 516425 524015 482870 485537 495679 523752 511496 524736 482997 483952 492718 493851 519510 522905 575841 581401 645276 400151 445728 490324 503105 510200 496088 564593 566217 567777 575151 584566 578410 576030 584421 696450 714109 551091 555850 560583 591385 599963 605794 611032 612607 621647 598184 624000 587397 625934 630500 795683 417497 431442 460824 467882 447079 470339 503619 489548 491409 495399 511508 541051 484127 488551 494780 498621 509324 485116 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые cum pussy"
]
|
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.