Query Metrics
7
Database Queries
7
Different statements
200.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.94 ms (86.65%) |
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 11330 394786 396563 396601 399596 403600 415105 419047 420742 425031 426411 430940 435274 448951 451528 451836 455877 457566 459319 464202 464643 465610 465998 468387 468939 469483 472076 472813 473363 474852 476792 479472 481777 482565 484487 486015 486204 489495 491447 492057 493159 493781 495130 499507 499803 502740 504823 505983 511518 512019 512623 516924 517859 519230 521409 522011 522069 523976 524987 525065 528937 534595 534759 536043 536046 541230 544265 544573 549568 552966 553290 554394 557012 558216 558310 558441 560085 560825 564175 567351 583079 587449 588370 588405 590267 590518 596872 597060 599991 600763 604480 606274 616419 620154 625216 626569 630115 671613 674184 685465 690053 692357 702149 703922 707462 718604 730046 731310 734736 739647 740117 740141 747138 756816 760786 786002 800803 805822 810197 821058 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (7.82%) |
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 730046 604480 457566 448951 489495 459319 465998 415105 504823 493159 468387 464202 473363 552966 567351 597060 590267 590518 626569 396563 544265 544573 486204 692357 451836 564175 560085 419047 821058 468939 495130 558310 702149 707462 625216 740117 805822 740141 756816 616419 718604 810197 558441 519230 516924 534595 493781 549568 560825 558216 630115 464643 479472 451528 476792 472076 499507 522011 523976 486015 511518 512019 528937 484487 492057 517859 472813 399596 465610 685465 396601 734736 499803 482565 502740 596872 435274 11330 512623 536043 505983 522069 536046 534759 525065 671613 674184 690053 703922 587449 599991 786002 800803 747138 760786 731310 739647 420742 474852 554394 583079 588370 620154 588405 455877 557012 394786 403600 426411 430940 469483 524987 553290 541230 600763 606274 425031 481777 491447 521409 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (1.88%) |
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 11330 394786 396563 396601 399596 403600 415105 419047 420742 425031 426411 430940 435274 448951 451528 451836 455877 457566 459319 464202 464643 465610 465998 468387 468939 469483 472076 472813 473363 474852 476792 479472 481777 482565 484487 486015 486204 489495 491447 492057 493159 493781 495130 499507 499803 502740 504823 505983 511518 512019 512623 516924 517859 519230 521409 522011 522069 523976 524987 525065 528937 534595 534759 536043 536046 541230 544265 544573 549568 552966 553290 554394 557012 558216 558310 558441 560085 560825 564175 567351 583079 587449 588370 588405 590267 590518 596872 597060 599991 600763 604480 606274 616419 620154 625216 626569 630115 671613 674184 685465 690053 692357 702149 703922 707462 718604 730046 731310 734736 739647 740117 740141 747138 756816 760786 786002 800803 805822 810197 821058 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings big cock"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел большие cock"
]
|
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.