Symfony Profiler

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1);

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )
  AND c.organisation REGEXP '^T'
ORDER BY
  c.organisation

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1) AND c.organisation REGEXP '^T'  ORDER BY c.organisation;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 8318

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=8318;

SELECT
  fr
FROM
  countries
WHERE
  id = 'TW'

SELECT fr FROM countries WHERE id='TW';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2062

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2062;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CA'

SELECT fr FROM countries WHERE id='CA';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3617

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3617;

SELECT
  fr
FROM
  countries
WHERE
  id = 'US'

SELECT fr FROM countries WHERE id='US';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 26805

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=26805;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 16486

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=16486;

SELECT
  fr
FROM
  countries
WHERE
  id = 'GB'

SELECT fr FROM countries WHERE id='GB';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17047

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17047;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 109

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=109;

SELECT
  fr
FROM
  countries
WHERE
  id = 'ES'

SELECT fr FROM countries WHERE id='ES';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6283

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6283;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 12204

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=12204;

SELECT
  fr
FROM
  countries
WHERE
  id = 'PT'

SELECT fr FROM countries WHERE id='PT';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6102

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6102;

SELECT
  fr
FROM
  countries
WHERE
  id = 'MX'

SELECT fr FROM countries WHERE id='MX';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1862

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1862;

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2822

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2822;

SELECT
  fr
FROM
  countries
WHERE
  id = 'GP'

SELECT fr FROM countries WHERE id='GP';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2413

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2413;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 34214

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=34214;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 5653

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=5653;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CN'

SELECT fr FROM countries WHERE id='CN';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 10512

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=10512;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2294

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2294;

SELECT
  fr
FROM
  countries
WHERE
  id = 'IE'

SELECT fr FROM countries WHERE id='IE';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3897

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3897;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 31200

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=31200;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 7707

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=7707;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1764

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1764;

SELECT
  fr
FROM
  countries
WHERE
  id = 'DE'

SELECT fr FROM countries WHERE id='DE';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 144

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=144;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 81

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=81;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2658

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2658;

SELECT
  fr
FROM
  countries
WHERE
  id = 'KR'

SELECT fr FROM countries WHERE id='KR';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 27340

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=27340;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1285

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1285;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 411

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=411;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 4453

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=4453;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 591

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=591;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 28164

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28164;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6723

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6723;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3743

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3743;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3243

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3243;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 82

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=82;

SELECT
  fr
FROM
  countries
WHERE
  id = 'AT'

SELECT fr FROM countries WHERE id='AT';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 8518

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=8518;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 14564

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=14564;

SELECT
  fr
FROM
  countries
WHERE
  id = 'IT'

SELECT fr FROM countries WHERE id='IT';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 108

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=108;

SELECT
  fr
FROM
  countries
WHERE
  id = 'TR'

SELECT fr FROM countries WHERE id='TR';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 26811

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=26811;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 140

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=140;

SELECT
  fr
FROM
  countries
WHERE
  id = 'NL'

SELECT fr FROM countries WHERE id='NL';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17863

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17863;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 18089

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=18089;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 48

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=48;

SELECT
  fr
FROM
  countries
WHERE
  id = 'UY'

SELECT fr FROM countries WHERE id='UY';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1395

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1395;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 28906

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28906;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 33

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=33;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20916

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20916;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_bottom = 1
  AND date_start <= NOW()
  AND date_end >= NOW()
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10;