Query Metrics
7
Database Queries
7
Different statements
167.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.88 ms (84.87%) |
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 78887 386243 389315 430380 435642 440737 448036 448046 450219 452137 454351 454361 455094 455115 456746 458753 461511 473545 475188 478526 479814 480991 481664 482120 483596 484352 485996 487065 491652 491665 491667 492040 496527 500463 500497 500506 504758 508823 508832 508844 510613 512241 512275 512321 513408 515334 516270 518756 519104 520032 524703 525248 525358 530911 533962 548669 552137 552151 552380 552783 560454 562201 562292 565046 567336 572316 572621 573345 575129 575791 576409 576413 580749 584245 587707 589345 597128 603609 605005 630916 655644 655664 655686 655737 655742 655965 657038 657039 657281 657329 657353 657381 658250 658568 659713 661300 678967 690117 697751 699412 705399 715693 719427 720237 720245 720249 729216 729220 729593 731326 733074 737054 742166 744509 802067 808332 824030 824528 825810 827959 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (9.00%) |
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 500463 500497 500506 520032 530911 519104 496527 513408 525248 485996 552380 565046 576413 552783 560454 575791 584245 657329 661300 678967 720237 720245 720249 719427 589345 802067 731326 630916 448036 481664 450219 448046 480991 482120 478526 435642 456746 479814 525358 491652 491665 491667 492040 518756 504758 515334 483596 516270 655686 655737 658250 699412 458753 389315 430380 824528 827959 452137 484352 533962 552137 562201 562292 573345 575129 576409 580749 548669 552151 697751 715693 690117 567336 572316 572621 587707 597128 808332 737054 744509 729216 729220 733074 742166 729593 603609 605005 705399 78887 454361 455115 475188 386243 473545 455094 461511 440737 454351 487065 508832 508844 512321 512275 508823 510613 512241 524703 824030 825810 655644 657038 659713 655742 657039 657353 658568 655664 655965 657281 657381 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.73%) |
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 78887 386243 389315 430380 435642 440737 448036 448046 450219 452137 454351 454361 455094 455115 456746 458753 461511 473545 475188 478526 479814 480991 481664 482120 483596 484352 485996 487065 491652 491665 491667 492040 496527 500463 500497 500506 504758 508823 508832 508844 510613 512241 512275 512321 513408 515334 516270 518756 519104 520032 524703 525248 525358 530911 533962 548669 552137 552151 552380 552783 560454 562201 562292 565046 567336 572316 572621 573345 575129 575791 576409 576413 580749 584245 587707 589345 597128 603609 605005 630916 655644 655664 655686 655737 655742 655965 657038 657039 657281 657329 657353 657381 658250 658568 659713 661300 678967 690117 697751 699412 705399 715693 719427 720237 720245 720249 729216 729220 729593 731326 733074 737054 742166 744509 802067 808332 824030 824528 825810 827959 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold xxx"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд xxx"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд xxx"
]
|
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.