Query Metrics
7
Database Queries
7
Different statements
119.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.11 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.30 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy pussy asian"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.05 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 630955 509821 522979 500688 528356 557207 623820 554428 423561 428417 430209 564767 586015 619450 593002 623814 737124 754179 623818 519903 552319 499498 453370 430444 418188 816260 512831 515803 572735 541337 564598 599186 812795 384368 619439 527669 797049 493298 519908 568621 435443 815330 485131 532161 516826 517687 538915 543812 558175 807688 522977 732211 552004 694373 510365 820871 556415 614401 471848 421287 412583 598865 493034 633165 622277 557537 827299 583851 551989 450386 448821 519242 587311 608395 452034 541593 421249 425993 804677 494059 650380 613174 521033 473055 512904 584627 583247 424970 460969 ] |
||||||||||||||||||||||||||||||
| 4 | 2.58 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 384368 412583 418188 421249 421287 423561 424970 425993 428417 430209 430444 435443 448821 450386 452034 453370 460969 471848 473055 485131 493034 493298 494059 499498 500688 509821 510365 512831 512904 515803 516826 517687 519242 519903 519908 521033 522977 522979 527669 528356 532161 538915 541337 541593 543812 551989 552004 552319 554428 556415 557207 557537 558175 564598 564767 568621 572735 583247 583851 584627 586015 587311 593002 598865 599186 608395 613174 614401 619439 619450 622277 623814 623818 623820 630955 633165 650380 694373 732211 737124 754179 797049 804677 807688 812795 815330 816260 820871 827299 ] |
||||||||||||||||||||||||||||||
| 5 | 94.81 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 384368 412583 418188 421249 421287 423561 424970 425993 428417 430209 430444 435443 448821 450386 452034 453370 460969 471848 473055 485131 493034 493298 494059 499498 500688 509821 510365 512831 512904 515803 516826 517687 519242 519903 519908 521033 522977 522979 527669 528356 532161 538915 541337 541593 543812 551989 552004 552319 554428 556415 557207 557537 558175 564598 564767 568621 572735 583247 583851 584627 586015 587311 593002 598865 599186 608395 613174 614401 619439 619450 622277 623814 623818 623820 630955 633165 650380 694373 732211 737124 754179 797049 804677 807688 812795 815330 816260 820871 827299 ] |
||||||||||||||||||||||||||||||
| 6 | 1.76 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая pussy азиатк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.51 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая pussy азиатк"
]
|
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.