Query Metrics
7
Database Queries
7
Different statements
342.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.70 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.94 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde cute girls"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.22 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 470230 595609 436444 461309 435799 423352 510506 515992 591016 404346 581877 442158 635144 601695 458870 561621 513002 514393 453791 406022 429490 470782 425948 518995 547757 593163 436049 456926 450754 514715 471754 461737 506665 562035 558064 561664 528104 498474 669936 567130 388591 461794 506556 549475 519563 466913 419625 523918 521016 493788 437610 456722 466860 442611 513031 527185 456518 643595 596168 443315 525686 569669 524060 476445 468579 473782 473526 514717 459612 658307 495163 499776 445366 455225 452227 389479 514768 565201 490198 462955 527975 453048 459535 563887 561704 601677 443320 621643 464062 ] |
||||||||||||||||||||||||||||||
| 4 | 3.79 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 388591 389479 404346 406022 419625 423352 425948 429490 435799 436049 436444 437610 442158 442611 443315 443320 445366 450754 452227 453048 453791 455225 456518 456722 456926 458870 459535 459612 461309 461737 461794 462955 464062 466860 466913 468579 470230 470782 471754 473526 473782 476445 490198 493788 495163 498474 499776 506556 506665 510506 513002 513031 514393 514715 514717 514768 515992 518995 519563 521016 523918 524060 525686 527185 527975 528104 547757 549475 558064 561621 561664 561704 562035 563887 565201 567130 569669 581877 591016 593163 595609 596168 601677 601695 621643 635144 643595 658307 669936 ] |
||||||||||||||||||||||||||||||
| 5 | 319.06 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 388591 389479 404346 406022 419625 423352 425948 429490 435799 436049 436444 437610 442158 442611 443315 443320 445366 450754 452227 453048 453791 455225 456518 456722 456926 458870 459535 459612 461309 461737 461794 462955 464062 466860 466913 468579 470230 470782 471754 473526 473782 476445 490198 493788 495163 498474 499776 506556 506665 510506 513002 513031 514393 514715 514717 514768 515992 518995 519563 521016 523918 524060 525686 527185 527975 528104 547757 549475 558064 561621 561664 561704 562035 563887 565201 567130 569669 581877 591016 593163 595609 596168 601677 601695 621643 635144 643595 658307 669936 ] |
||||||||||||||||||||||||||||||
| 6 | 1.83 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая cute девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.44 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая cute девушк"
]
|
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.