Query Metrics
7
Database Queries
7
Different statements
281.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.52 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.71 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"попа лапать"
]
|
||||||||||||||||||||||||||||||
| 3 | 20.80 ms |
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 436582 597283 568411 521136 507129 493217 592574 552886 517764 516385 629506 456694 652004 627774 492017 362000 663533 589568 513975 600822 528183 447349 522045 572220 584092 671866 574240 477099 660457 488240 485687 457453 502190 503655 553971 654770 430786 533145 571155 480125 557324 600123 598271 467733 523771 552123 583428 581806 625770 609998 551973 469142 552022 486927 466749 563927 522344 566011 566673 579761 506342 570421 610209 520804 750347 519844 554319 588151 578166 723243 516056 618946 625874 751255 551541 580269 782135 611486 803104 580913 680476 799845 747349 562184 404078 636977 601105 459048 563914 711843 584120 543936 548393 456875 544057 795837 752295 663540 543288 562850 568583 522437 464028 511546 563923 756363 810800 527098 602146 596260 565879 602490 529442 523897 512421 566008 608156 605939 609990 495672 ] |
||||||||||||||||||||||||||||||
| 4 | 2.72 ms |
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 362000 404078 430786 436582 447349 456694 456875 457453 459048 464028 466749 467733 469142 477099 480125 485687 486927 488240 492017 493217 495672 502190 503655 506342 507129 511546 512421 513975 516056 516385 517764 519844 520804 521136 522045 522344 522437 523771 523897 527098 528183 529442 533145 543288 543936 544057 548393 551541 551973 552022 552123 552886 553971 554319 557324 562184 562850 563914 563923 563927 565879 566008 566011 566673 568411 568583 570421 571155 572220 574240 578166 579761 580269 580913 581806 583428 584092 584120 588151 589568 592574 596260 597283 598271 600123 600822 601105 602146 602490 605939 608156 609990 609998 610209 611486 618946 625770 625874 627774 629506 636977 652004 654770 660457 663533 663540 671866 680476 711843 723243 747349 750347 751255 752295 756363 782135 795837 799845 803104 810800 ] |
||||||||||||||||||||||||||||||
| 5 | 251.51 ms |
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 362000 404078 430786 436582 447349 456694 456875 457453 459048 464028 466749 467733 469142 477099 480125 485687 486927 488240 492017 493217 495672 502190 503655 506342 507129 511546 512421 513975 516056 516385 517764 519844 520804 521136 522045 522344 522437 523771 523897 527098 528183 529442 533145 543288 543936 544057 548393 551541 551973 552022 552123 552886 553971 554319 557324 562184 562850 563914 563923 563927 565879 566008 566011 566673 568411 568583 570421 571155 572220 574240 578166 579761 580269 580913 581806 583428 584092 584120 588151 589568 592574 596260 597283 598271 600123 600822 601105 602146 602490 605939 608156 609990 609998 610209 611486 618946 625770 625874 627774 629506 636977 652004 654770 660457 663533 663540 671866 680476 711843 723243 747349 750347 751255 752295 756363 782135 795837 799845 803104 810800 ] |
||||||||||||||||||||||||||||||
| 6 | 1.66 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп трога"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.24 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.