Query Metrics
7
Database Queries
7
Different statements
169.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.27 ms (87.84%) |
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 34645 80360 183506 351650 384124 384268 388762 390925 393496 395985 396317 396333 396758 397062 404279 408465 417006 418441 419154 420495 425019 429552 446762 447211 453516 453884 454183 456611 457403 458101 458713 460387 463637 466064 469300 470260 477991 479189 485264 485913 489073 491661 492448 494384 495147 501342 501905 504345 505928 506255 512259 513937 514321 514919 521179 522252 522830 523248 523289 523731 526044 526682 528805 532008 541550 560484 561813 568728 579958 584441 587103 592591 593168 593856 599501 601404 604370 606796 606995 608635 610197 613414 620491 626122 639219 642779 661295 668467 670806 685514 695479 714580 716640 726289 731315 736378 741937 742356 742390 754900 763471 764326 765313 771794 776266 777110 779928 782179 786172 786576 786732 788623 794455 801325 802472 807811 810530 814586 817666 818005 ] |
||||||||||||||||||||||||||||||
|
11.67 ms (6.87%) |
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 489073 579958 404279 523731 526044 456611 429552 393496 532008 523289 384124 419154 470260 420495 587103 601404 613414 764326 395985 771794 794455 501342 685514 786576 34645 786732 80360 501905 463637 779928 418441 514321 742390 608635 714580 592591 786172 457403 458101 506255 736378 661295 425019 765313 741937 593168 513937 593856 606995 466064 522252 695479 668467 460387 447211 528805 397062 639219 731315 726289 807811 485264 390925 523248 584441 599501 810530 396758 458713 716640 494384 604370 742356 526682 802472 560484 620491 670806 754900 388762 495147 183506 814586 610197 568728 776266 454183 777110 477991 782179 522830 492448 606796 521179 408465 512259 384268 818005 788623 801325 396317 453884 642779 485913 541550 817666 351650 417006 446762 453516 514919 561813 396333 626122 763471 504345 491661 505928 469300 479189 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.51%) |
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 34645 80360 183506 351650 384124 384268 388762 390925 393496 395985 396317 396333 396758 397062 404279 408465 417006 418441 419154 420495 425019 429552 446762 447211 453516 453884 454183 456611 457403 458101 458713 460387 463637 466064 469300 470260 477991 479189 485264 485913 489073 491661 492448 494384 495147 501342 501905 504345 505928 506255 512259 513937 514321 514919 521179 522252 522830 523248 523289 523731 526044 526682 528805 532008 541550 560484 561813 568728 579958 584441 587103 592591 593168 593856 599501 601404 604370 606796 606995 608635 610197 613414 620491 626122 639219 642779 661295 668467 670806 685514 695479 714580 716640 726289 731315 736378 741937 742356 742390 754900 763471 764326 765313 771794 776266 777110 779928 782179 786172 786576 786732 788623 794455 801325 802472 807811 810530 814586 817666 818005 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom blowjob sperm"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.