Query Metrics
7
Database Queries
7
Different statements
201.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.70 ms (81.32%) |
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 182766 381952 391754 391954 398543 409374 409934 410267 411054 411946 414767 423935 424721 425385 429598 429869 441858 441985 444020 445409 452936 457577 467903 468241 469393 470191 471113 472421 474874 479979 480870 490399 490731 491097 501342 503506 506260 506674 508807 509603 517736 518595 520813 526473 526645 529400 529512 535818 537827 544441 546884 556762 558179 565687 566777 569133 569271 569376 576772 583027 583577 584377 586007 587272 589578 591669 593016 593044 593540 594293 596779 599354 600932 600951 602222 602328 604698 607541 607716 610083 618587 629606 629810 632107 634746 639119 666704 668700 699765 713031 715277 731783 744391 755020 781802 781921 785106 794237 796328 796453 796933 800755 800807 804444 804600 804729 810606 813807 814188 824685 824846 825324 825365 825439 826703 827143 827183 827502 827693 827724 ] |
||||||||||||||||||||||||||||||
|
24.88 ms (12.36%) |
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 583577 544441 546884 583027 569271 593016 593044 596779 607541 602328 594293 391954 472421 480870 479979 526473 490399 526645 520813 491097 824846 425385 409374 411054 826703 825324 827143 827183 827724 827502 827693 825365 824685 825439 537827 535818 566777 576772 668700 715277 713031 569376 589578 591669 602222 604698 629606 618587 629810 600932 600951 781802 781921 796453 804444 804600 794237 796328 796933 800755 800807 804729 744391 755020 731783 699765 785106 445409 508807 411946 410267 444020 506674 569133 556762 587272 586007 810606 610083 634746 423935 452936 474874 409934 414767 441985 424721 457577 468241 469393 509603 518595 503506 517736 529400 506260 558179 584377 666704 565687 593540 599354 632107 639119 607716 467903 429598 429869 470191 471113 391754 441858 529512 501342 490731 182766 381952 398543 813807 814188 ] |
||||||||||||||||||||||||||||||
|
4.34 ms (2.15%) |
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 182766 381952 391754 391954 398543 409374 409934 410267 411054 411946 414767 423935 424721 425385 429598 429869 441858 441985 444020 445409 452936 457577 467903 468241 469393 470191 471113 472421 474874 479979 480870 490399 490731 491097 501342 503506 506260 506674 508807 509603 517736 518595 520813 526473 526645 529400 529512 535818 537827 544441 546884 556762 558179 565687 566777 569133 569271 569376 576772 583027 583577 584377 586007 587272 589578 591669 593016 593044 593540 594293 596779 599354 600932 600951 602222 602328 604698 607541 607716 610083 618587 629606 629810 632107 634746 639119 666704 668700 699765 713031 715277 731783 744391 755020 781802 781921 785106 794237 796328 796453 796933 800755 800807 804444 804600 804729 810606 813807 814188 824685 824846 825324 825365 825439 826703 827143 827183 827502 827693 827724 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby dildo"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby дилд"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby дилд"
]
|
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.