|
SELECT cat.* FROM `vigicom_packages`.`category` cat WHERE 1=1 AND cat.`id_part_package` IN ( 255 ) AND cat.`publication` = 'published' ORDER BY cat.`order` ASC, cat.`id_category` ASC ;
|
87.02µs |
internal simple |
|
SELECT SQL_CALC_FOUND_ROWS article.`id_article`, article.`id_part_package`, article.`creation_datetime`, article.`creation_user`, article.`modification_datetime`, article.`modification_user`, article.`title`, article.`header`, GROUP_CONCAT( DISTINCT article_category.`id_category` SEPARATOR ',' ) AS `categories`, article.`content`, article.`thumb`, article.`thumb_legend`, article.`photo`, article.`visu`, article.`video_link`, GROUP_CONCAT( CONCAT_WS('-', article_file.`id_file`, article_file.`id_file_overview` ) SEPARATOR ',' ) AS `files`, GROUP_CONCAT( DISTINCT CONCAT_WS('-', article_video.`video`, article_video.`image`) SEPARATOR ',' ) AS `videos`, ( SELECT GROUP_CONCAT( `photo` ORDER BY `order` ASC SEPARATOR ',' ) FROM `vigicom_packages`.`article_photo` article_photo WHERE article_photo.`id_article` = article.`id_article` ) AS `photos`, ( SELECT GROUP_CONCAT( IF( `photo_thumb` IS NULL, '', `photo_thumb` ) ORDER BY `order` ASC SEPARATOR ',' ) FROM `vigicom_packages`.`article_photo` article_photo WHERE article_photo.`id_article` = article.`id_article` ) AS `photos_thumb`, article.`language`, article.`in_evidence`, article.`publication`, ( SELECT title FROM `vigicom_packages`.`category` WHERE id_category = ( SELECT id_category FROM `vigicom_packages`.`article_category` ac WHERE ac.id_article = article_category.id_article LIMIT 1 ) ) AS `category_title`, ( SELECT `order` FROM `vigicom_packages`.`category` WHERE id_category = ( SELECT id_category FROM `vigicom_packages`.`article_category` ac WHERE ac.id_article = article_category.id_article LIMIT 1 ) ) AS `category_order` FROM `vigicom_packages`.`article` article LEFT JOIN `vigicom_packages`.`article_video` article_video ON ( article_video.`id_article` = article.`id_article` ) LEFT JOIN `vigicom_packages`.`article_file` article_file ON ( article_file.`id_article` = article.`id_article` ) LEFT JOIN `vigicom_packages`.`article_category` article_category ON ( article_category.`id_article` = article.`id_article` ) WHERE 1=1 AND article.`id_part_package` IN ( 266 ) AND article.`publication`='published' AND article_category.`id_category`=1314 GROUP BY article.`id_article` ORDER BY category_order ASC, article.`creation_datetime` DESC, article.`id_article` DESC ;
|
139.95µs |
internal simple |
|
SELECT FOUND_ROWS() AS `nbRows`;
|
82.02µs |
internal simple |
|
SELECT count(*) as nb FROM `vigicom_packages`.`article` article LEFT JOIN `vigicom_packages`.`category` category ON ( category.`id_category` = article.`id_category` ) LEFT JOIN `vigicom_packages`.`needprofile_announce` announce ON ( announce.`id_article` = article.`id_article` ) LEFT JOIN `vigicom_packages`.`geography_city` city ON ( announce.`city` = city.`id_geography_city` ) LEFT JOIN `vigicom_packages`.`needprofile_company` company ON ( announce.`id_company` = company.`id_group` ) WHERE 1=1 AND article.`id_part_package`=253 AND article.`publication` LIKE _utf8'published' AND announce.`archived` = '0' ;
|
55.07µs |
internal simple |
|
SELECT SQL_CALC_FOUND_ROWS grp.*, company.* , article.`title` as title, article.`publication`, annonce.`archived`, COUNT(*) AS `nb_members`, GROUP_CONCAT( DISTINCT cgrp.`id_customer` SEPARATOR ',' ) AS `accounts` FROM `vigicom_packages`.`group` grp LEFT JOIN `vigicom_packages`.`customer_group` cgrp ON ( cgrp.`id_group` = grp.`id_group` ) LEFT JOIN `vigicom_packages`.`needprofile_company` company ON ( company.`id_group` = grp.`id_group` ) LEFT JOIN `vigicom_packages`.`needprofile_announce` annonce ON ( annonce.`id_company` = grp.`id_group` ) LEFT JOIN `vigicom_packages`.`article` article ON ( article.`id_article` = annonce.`id_article` ) WHERE 1=1 AND grp.`id_part_package`=257 AND article.`title` IS NOT NULL AND article.`publication` ="published" AND annonce.`archived` = '0' GROUP BY grp.`id_group` ORDER BY grp.`creation_datetime` DESC, grp.`id_group` DESC LIMIT 0, 3 ;
|
73.91µs |
internal simple |
|
SELECT `data`, `need_update` FROM `vigicom_packages`.`customer_session` WHERE `sid`=_utf8'dasr2it9b0mng2p6c7jk9b38a3' AND `hash`=_utf8'f528764d624db129b32c21fbca0cb8d6' LIMIT 1;
|
212.91µs |
internal simple |
|
INSERT INTO `vigisite`.`log` ( `id_customer`, `error_code`, `datetime`, `information`, `ip`, `host`, `user_agent` ) VALUES ( NULL, '0x0005100E', NOW(), _utf8'[]', '127.0.0.1', 'localhost.localdomain', 'CCBot/2.0' );
|
146.87µs |
internal simple |
|
SELECT cat.* FROM `vigicom_packages`.`category` cat WHERE 1=1 AND cat.`id_part_package` IN ( _utf8'254', _utf8'255', _utf8'250', _utf8'336' ) AND cat.`publication` = 'published' ORDER BY cat.`order` ASC, cat.`id_category` ASC ;
|
97.04µs |
internal simple |
|
SELECT slide.* FROM `vigicom_packages`.`slide` slide WHERE 1=1 AND slide.`id_part_package`=270 AND slide.`published` = '1' ORDER BY slide.`order` ASC, slide.`id_slide` ASC ;
|
58.89µs |
internal simple |
|
SELECT file.*, CONCAT( server.`http_basedir`, file.`path`, '-', file.`access_key`, '/', file.`name`, IF( file.`extension` IS NOT NULL AND file.`extension` != '', CONCAT( '.', file.`extension` ), '' ), '?', UNIX_TIMESTAMP( IF( file.`modification_datetime` IS NULL, file.`creation_datetime`, file.`modification_datetime` ) ) ) AS `http_link` FROM `vigicom_packages`.`library_file` file JOIN `vigicom_packages`.`library_server` server ON ( server.`id_server` = file.`id_server` ) WHERE 1 = 1 AND file.`id_file` IN ( 6455,4326,4319,4322 ) AND file.`id_part`=25 ;
|
61.99µs |
internal simple |
|
SELECT cat.* FROM `vigicom_packages`.`category` cat WHERE 1=1 AND cat.`id_part_package` IN ( 268 ) AND cat.`publication` = 'published' ORDER BY cat.`order` ASC, cat.`id_category` ASC ;
|
170.95µs |
internal simple |
|
SELECT cat.* FROM `vigicom_packages`.`category` cat WHERE 1=1 AND cat.`id_part_package` IN ( 261 ) AND cat.`publication` = 'published' ORDER BY cat.`order` ASC, cat.`id_category` ASC ;
|
94.89µs |
internal simple |
|
SELECT city.zip AS id_department, city.region_2 as department_name,city.region_1 as region_name FROM `vigicom_packages`.`geography_city` city WHERE 1=1 AND city.`zip` IS NOT NULL AND city.`region_1` IS NOT NULL AND city.`region_2` IS NOT NULL GROUP BY city.`region_2` ASC ORDER BY id_department ASC ;
|
67µs |
internal simple |
|
SELECT SQL_CALC_FOUND_ROWS grp.*, company.* , COUNT(*) AS `nb_members`, GROUP_CONCAT( DISTINCT cgrp.`id_customer` SEPARATOR ',' ) AS `accounts` FROM `vigicom_packages`.`group` grp LEFT JOIN `vigicom_packages`.`customer_group` cgrp ON ( cgrp.`id_group` = grp.`id_group` ) LEFT JOIN `vigicom_packages`.`needprofile_company` company ON ( company.`id_group` = grp.`id_group` ) WHERE 1=1 AND grp.`id_part_package`=320 GROUP BY grp.`id_group` ORDER BY grp.`creation_datetime` DESC, grp.`id_group` DESC ;
|
75.1µs |
internal simple |
|
SELECT file.*, CONCAT( server.`http_basedir`, file.`path`, '-', file.`access_key`, '/', file.`name`, IF( file.`extension` IS NOT NULL AND file.`extension` != '', CONCAT( '.', file.`extension` ), '' ) ) AS `http_link` FROM `vigicom_packages`.`library_file` file JOIN `vigicom_packages`.`library_server` server ON ( server.`id_server` = file.`id_server` ) WHERE file.`id_file` IN ( 13149, 7592, 7582, 6198, 7589 );
|
61.04µs |
internal simple |
|
SELECT SQL_CALC_FOUND_ROWS article.`id_article`, article.`id_part_package`, article.`creation_datetime`, article.`creation_user`, article.`modification_datetime`, article.`modification_user`, article.`title`, article.`header`, GROUP_CONCAT( DISTINCT article_category.`id_category` SEPARATOR ',' ) AS `categories`, article.`content`, article.`thumb`, article.`thumb_legend`, article.`photo`, article.`visu`, article.`video_link`, GROUP_CONCAT( CONCAT_WS('-', article_file.`id_file`, article_file.`id_file_overview` ) SEPARATOR ',' ) AS `files`, GROUP_CONCAT( DISTINCT CONCAT_WS('-', article_video.`video`, article_video.`image`) SEPARATOR ',' ) AS `videos`, ( SELECT GROUP_CONCAT( `photo` ORDER BY `order` ASC SEPARATOR ',' ) FROM `vigicom_packages`.`article_photo` article_photo WHERE article_photo.`id_article` = article.`id_article` ) AS `photos`, ( SELECT GROUP_CONCAT( IF( `photo_thumb` IS NULL, '', `photo_thumb` ) ORDER BY `order` ASC SEPARATOR ',' ) FROM `vigicom_packages`.`article_photo` article_photo WHERE article_photo.`id_article` = article.`id_article` ) AS `photos_thumb`, article.`language`, article.`in_evidence`, article.`publication`, ( SELECT title FROM `vigicom_packages`.`category` WHERE id_category = ( SELECT id_category FROM `vigicom_packages`.`article_category` ac WHERE ac.id_article = article_category.id_article LIMIT 1 ) ) AS `category_title`, ( SELECT `order` FROM `vigicom_packages`.`category` WHERE id_category = ( SELECT id_category FROM `vigicom_packages`.`article_category` ac WHERE ac.id_article = article_category.id_article LIMIT 1 ) ) AS `category_order` FROM `vigicom_packages`.`article` article LEFT JOIN `vigicom_packages`.`article_video` article_video ON ( article_video.`id_article` = article.`id_article` ) LEFT JOIN `vigicom_packages`.`article_file` article_file ON ( article_file.`id_article` = article.`id_article` ) LEFT JOIN `vigicom_packages`.`article_category` article_category ON ( article_category.`id_article` = article.`id_article` ) WHERE 1=1 AND article.`id_part_package` IN ( 324 ) AND article.`publication`='published' GROUP BY article.`id_article` ORDER BY category_order ASC, article.`creation_datetime` DESC, article.`id_article` DESC ;
|
77.96µs |
internal simple |
|
SELECT FOUND_ROWS() AS `nbRows`;
|
58.89µs |
internal simple |
|
SELECT file.*, CONCAT( server.`http_basedir`, file.`path`, '-', file.`access_key`, '/', file.`name`, IF( file.`extension` IS NOT NULL AND file.`extension` != '', CONCAT( '.', file.`extension` ), '' ) ) AS `http_link` FROM `vigicom_packages`.`library_file` file JOIN `vigicom_packages`.`library_server` server ON ( server.`id_server` = file.`id_server` ) WHERE file.`id_file` IN ( 7567 );
|
62.23µs |
internal simple |
|
SELECT package.`system_name`, package.`version` FROM `vigisite`.`package` package;
|
46.01µs |
internal simple |
« Attachant beaucoup d’importance aux entreprises locales, j’ai tout de suite été séduit par le concept Needprofile qui fait enfin tomber les barrières financières des sites d’emploi.
S'inscrire à notre Newsletter
Devenir fan sur Facebook
Nous suivre sur Viadeo