Query Metrics
7
Database Queries
7
Different statements
212.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.07 ms (86.76%) |
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 4446 7441 83943 148101 187843 188034 191246 197358 206144 223019 233532 312476 384905 386791 390566 398973 399966 400722 401064 401964 402386 404432 407809 411346 419521 420016 422155 422184 422192 422197 422212 423299 424931 425251 426434 426511 426512 426531 426686 428602 431341 432852 434608 437303 437947 439627 439635 440781 442084 442377 443165 445459 447981 448727 452100 454239 454501 457010 460768 460918 463260 464835 465581 466150 467003 471417 472592 474582 476291 477116 477588 478369 480497 481751 481907 482392 483149 485160 489987 490423 491399 492120 492440 493177 493584 495038 498447 502809 505956 508575 509647 516021 518957 534621 544575 549842 564337 566980 580017 619096 637402 684067 708161 715475 715894 725378 735799 738202 744226 759756 761084 761134 784313 788173 796211 801549 802138 807866 808533 814369 ] |
||||||||||||||||||||||||||||||
|
17.72 ms (8.35%) |
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 399966 619096 480497 443165 384905 735799 495038 796211 784313 390566 457010 508575 442084 454239 460768 498447 426434 549842 788173 419521 489987 490423 505956 485160 502809 738202 191246 471417 460918 463260 312476 684067 426686 188034 7441 400722 715894 808533 420016 83943 807866 386791 398973 708161 802138 401064 492440 425251 426531 516021 534621 404432 423299 759756 447981 814369 744226 467003 491399 637402 466150 439635 509647 492120 493177 197358 448727 206144 432852 440781 566980 428602 715475 223019 401964 411346 580017 801549 434608 477588 439627 464835 465581 442377 518957 454501 725378 761084 148101 483149 476291 481907 478369 422155 437947 493584 564337 426511 422184 422192 422212 187843 472592 431341 452100 445459 424931 481751 761134 422197 4446 407809 474582 233532 544575 437303 402386 426512 477116 482392 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother tits"
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (1.12%) |
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 4446 7441 83943 148101 187843 188034 191246 197358 206144 223019 233532 312476 384905 386791 390566 398973 399966 400722 401064 401964 402386 404432 407809 411346 419521 420016 422155 422184 422192 422197 422212 423299 424931 425251 426434 426511 426512 426531 426686 428602 431341 432852 434608 437303 437947 439627 439635 440781 442084 442377 443165 445459 447981 448727 452100 454239 454501 457010 460768 460918 463260 464835 465581 466150 467003 471417 472592 474582 476291 477116 477588 478369 480497 481751 481907 482392 483149 485160 489987 490423 491399 492120 492440 493177 493584 495038 498447 502809 505956 508575 509647 516021 518957 534621 544575 549842 564337 566980 580017 619096 637402 684067 708161 715475 715894 725378 735799 738202 744226 759756 761084 761134 784313 788173 796211 801549 802138 807866 808533 814369 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.71%) |
1 |
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.