Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "escort russian"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'escort russian' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  766783
  817999
  763956
  530044
  543751
  768296
  797811
  561250
  777210
  653661
  436845
  543653
  793271
  790520
  426984
  457334
  779001
  784407
  782913
  761895
  490439
  588958
  779564
  406040
  433950
  434746
  449643
  779495
  797790
  425737
  782602
  426840
  486228
  556492
  454938
  485878
  579106
  560358
  771398
  423488
  433921
  527904
  529456
  426663
  468809
  422824
  499951
  650056
  464526
  432962
  501494
  779567
  456737
  500839
  590633
  442556
  621179
  437599
  520427
  517329
  548304
  425260
  514062
  514404
  423317
  509697
  517358
  587056
  579345
  499597
  510025
  587248
  606014
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (766783, 817999, 763956, 530044, 543751, 768296, 797811, 561250, 777210, 653661, 436845, 543653, 793271, 790520, 426984, 457334, 779001, 784407, 782913, 761895, 490439, 588958, 779564, 406040, 433950, 434746, 449643, 779495, 797790, 425737, 782602, 426840, 486228, 556492, 454938, 485878, 579106, 560358, 771398, 423488, 433921, 527904, 529456, 426663, 468809, 422824, 499951, 650056, 464526, 432962, 501494, 779567, 456737, 500839, 590633, 442556, 621179, 437599, 520427, 517329, 548304, 425260, 514062, 514404, 423317, 509697, 517358, 587056, 579345, 499597, 510025, 587248, 606014);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  406040
  422824
  423317
  423488
  425260
  425737
  426663
  426840
  426984
  432962
  433921
  433950
  434746
  436845
  437599
  442556
  449643
  454938
  456737
  457334
  464526
  468809
  485878
  486228
  490439
  499597
  499951
  500839
  501494
  509697
  510025
  514062
  514404
  517329
  517358
  520427
  527904
  529456
  530044
  543653
  543751
  548304
  556492
  560358
  561250
  579106
  579345
  587056
  587248
  588958
  590633
  606014
  621179
  650056
  653661
  761895
  763956
  766783
  768296
  771398
  777210
  779001
  779495
  779564
  779567
  782602
  782913
  784407
  790520
  793271
  797790
  797811
  817999
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (406040, 422824, 423317, 423488, 425260, 425737, 426663, 426840, 426984, 432962, 433921, 433950, 434746, 436845, 437599, 442556, 449643, 454938, 456737, 457334, 464526, 468809, 485878, 486228, 490439, 499597, 499951, 500839, 501494, 509697, 510025, 514062, 514404, 517329, 517358, 520427, 527904, 529456, 530044, 543653, 543751, 548304, 556492, 560358, 561250, 579106, 579345, 587056, 587248, 588958, 590633, 606014, 621179, 650056, 653661, 761895, 763956, 766783, 768296, 771398, 777210, 779001, 779495, 779564, 779567, 782602, 782913, 784407, 790520, 793271, 797790, 797811, 817999);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  406040
  422824
  423317
  423488
  425260
  425737
  426663
  426840
  426984
  432962
  433921
  433950
  434746
  436845
  437599
  442556
  449643
  454938
  456737
  457334
  464526
  468809
  485878
  486228
  490439
  499597
  499951
  500839
  501494
  509697
  510025
  514062
  514404
  517329
  517358
  520427
  527904
  529456
  530044
  543653
  543751
  548304
  556492
  560358
  561250
  579106
  579345
  587056
  587248
  588958
  590633
  606014
  621179
  650056
  653661
  761895
  763956
  766783
  768296
  771398
  777210
  779001
  779495
  779564
  779567
  782602
  782913
  784407
  790520
  793271
  797790
  797811
  817999
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (406040, 422824, 423317, 423488, 425260, 425737, 426663, 426840, 426984, 432962, 433921, 433950, 434746, 436845, 437599, 442556, 449643, 454938, 456737, 457334, 464526, 468809, 485878, 486228, 490439, 499597, 499951, 500839, 501494, 509697, 510025, 514062, 514404, 517329, 517358, 520427, 527904, 529456, 530044, 543653, 543751, 548304, 556492, 560358, 561250, 579106, 579345, 587056, 587248, 588958, 590633, 606014, 621179, 650056, 653661, 761895, 763956, 766783, 768296, 771398, 777210, 779001, 779495, 779564, 779567, 782602, 782913, 784407, 790520, 793271, 797790, 797811, 817999);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "escort русск"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'escort русск';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "escort русск"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'escort русск';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "escort russian"
  "escort russian"
  "escort russian"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('escort russian') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('escort russian')
              AND `query` <> 'escort russian'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;