Query Metrics
7
Database Queries
7
Different statements
218.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.01 ms (88.05%) |
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 383643 390571 395973 415631 416874 417065 417656 419860 420351 422389 424415 424492 425477 425491 426368 426606 427454 428532 429559 429675 429952 431596 432081 437686 439626 440581 442238 442276 448034 448798 448987 451258 451558 452489 453036 456897 459471 461231 462361 462365 466259 468710 468911 469263 470181 471956 473182 473837 476107 476721 479728 479826 480245 481679 483124 484860 487907 489621 490428 490729 490928 490945 491227 491286 491320 491654 491947 492119 492414 493209 494705 495235 496086 496603 496884 497866 500375 500430 500860 502485 502907 508595 508819 508834 508874 509025 509389 509677 511812 512073 513274 513341 514275 514384 516776 518382 519039 519549 519769 523321 523608 527576 527630 527632 528101 528110 533557 534797 537247 538372 539058 559140 560201 560209 561110 561114 579391 613319 638991 730072 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (7.25%) |
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 730072 383643 429952 431596 469263 476721 481679 424415 425491 428532 429559 452489 453036 462365 468911 451558 459471 470181 468710 424492 426606 462361 466259 508595 539058 483124 484860 489621 490729 491320 491654 491947 494705 508834 508874 513274 513341 527630 528110 490928 493209 495235 496884 500860 509677 514384 538372 487907 490945 491227 502907 508819 509025 509389 514275 523321 523608 527632 437686 448987 496603 527576 496086 516776 559140 579391 560201 560209 561114 638991 613319 390571 439626 448798 448034 479826 419860 440581 420351 490428 512073 519549 519769 491286 500375 518382 561110 432081 426368 476107 537247 528101 534797 415631 427454 422389 473182 511812 500430 497866 519039 502485 533557 395973 429675 442276 425477 416874 442238 417065 417656 471956 480245 451258 456897 473837 479728 492119 492414 461231 ] |
||||||||||||||||||||||||||||||
|
4.12 ms (1.89%) |
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 383643 390571 395973 415631 416874 417065 417656 419860 420351 422389 424415 424492 425477 425491 426368 426606 427454 428532 429559 429675 429952 431596 432081 437686 439626 440581 442238 442276 448034 448798 448987 451258 451558 452489 453036 456897 459471 461231 462361 462365 466259 468710 468911 469263 470181 471956 473182 473837 476107 476721 479728 479826 480245 481679 483124 484860 487907 489621 490428 490729 490928 490945 491227 491286 491320 491654 491947 492119 492414 493209 494705 495235 496086 496603 496884 497866 500375 500430 500860 502485 502907 508595 508819 508834 508874 509025 509389 509677 511812 512073 513274 513341 514275 514384 516776 518382 519039 519549 519769 523321 523608 527576 527630 527632 528101 528110 533557 534797 537247 538372 539058 559140 560201 560209 561110 561114 579391 613319 638991 730072 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy lick slave"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy лиза доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.56%) |
1 |
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.