EUROMED VOYAGES: 7 RUE DES LOMBARDS, 80000 AMIENS, FRANCE

Opening DB connection

Querying SQL: SHOW COLUMNS FROM `domain`

Querying SQL: SHOW CREATE TABLE `domain`

domain.find()

Querying SQL: SELECT * FROM `domain` `t` WHERE name = :name LIMIT 1

Querying SQL: SELECT t1.message AS message, t2.translation AS translation
FROM SourceMessage t1, Message t2
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language

Querying SQL: SHOW COLUMNS FROM `langue`

Querying SQL: SHOW CREATE TABLE `langue`

langue.findAllByAttributes()

Querying SQL: SELECT * FROM `langue` `t` WHERE `t`.`statut`=:yp0

langue.find()

Querying SQL: SELECT * FROM `langue` `t` WHERE `nom`='fr' LIMIT 1

Querying SQL: SELECT t1.message AS message, t2.translation AS translation
FROM SourceMessage t1, Message t2
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language

Querying SQL: SELECT show_journey FROM domain WHERE id = '1'

Querying SQL: SELECT `j`.`Description`, `j`.`from_country_id`,  `j`.`id`,
`j`.`company_id`, `c`.`nom`
                        FROM `domain_journey` as `dj`
                        LEFT JOIN `journey` as `j`
                        ON `dj`.`journey_id`=`j`.`id`
                        LEFT JOIN `domain` as `d`
                        ON `dj`.`domain_id`=`d`.`id`
                        LEFT JOIN `compagnies` as `c`
                        ON `j`.`company_id` = `c`.`id`
                        WHERE
                        d.show_journey = 0
                        AND `d`.`id`='1'
						AND d.app_type=1
                        AND j.Activation=1 order by `j`.`from_country_id`

Querying SQL: SHOW COLUMNS FROM `journey`

Querying SQL: SHOW CREATE TABLE `journey`

Querying SQL: SELECT show_journey FROM domain WHERE id = '1'

Querying SQL: SELECT `j`.`Description`, `j`.`id`, `j`.`company_id`,
`c`.`nom`,`j`.`from_country_id`,`j`.`to_country_id`,`cc`.`NameFR`,`ccc`.`NameFR`
as rNameFr
                        FROM `domain_journey` as `dj`
                        LEFT JOIN `journey` as `j`
                        ON `dj`.`journey_id`=`j`.`id`
                        LEFT JOIN `domain` as `d`
                        ON `dj`.`domain_id`=`d`.`id`
                        LEFT JOIN `compagnies` as `c`
                        ON `j`.`company_id` = `c`.`id` 
						LEFT JOIN `countrylist` as `cc`
                        ON `j`.`from_country_id` = `cc`.`id`
						LEFT JOIN  `countrylist` AS  `ccc` 
						ON  `j`.`to_country_id` =  `ccc`.`id` 
                        WHERE
                        d.show_journey = 0
                        AND `d`.`id`='1'
						AND d.app_type=1
                        AND j.Activation=1 order by 
j.from_country_id,j.to_country_id,j.Description ASC

Querying SQL: SELECT t1.message AS message, t2.translation AS translation
FROM SourceMessage t1, Message t2
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language

Querying SQL: SELECT `ip` FROM `online` WHERE `ip`='38.107.179.209' AND
`user_id`='NULL'

Executing SQL: INSERT INTO online (user_id,ip,time,frontend)
                VALUES ('NULL','38.107.179.209','1337502961','1')

Querying SQL: SHOW COLUMNS FROM `online`

Querying SQL: SHOW CREATE TABLE `online`

online.deleteAll()

Executing SQL: DELETE FROM `online` WHERE time<:t

Querying SQL: SELECT t1.message AS message, t2.translation AS translation
FROM SourceMessage t1, Message t2
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language

Querying SQL: SELECT t1.message AS message, t2.translation AS translation
FROM SourceMessage t1, Message t2
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language

Querying SQL: SELECT t1.message AS message, t2.translation AS translation
FROM SourceMessage t1, Message t2
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language

Querying SQL: SHOW COLUMNS FROM `banner`

Querying SQL: SHOW CREATE TABLE `banner`

banner.findAll()

Querying SQL: SELECT * FROM `banner` `t` WHERE site="maroc-ferry.com"

domain.find()

Querying SQL: SELECT * FROM `domain` `t` WHERE identifier = :host LIMIT 1

langue.find()

Querying SQL: SELECT * FROM `langue` `t` WHERE nom = :lang LIMIT 1

Querying SQL: SHOW COLUMNS FROM `news`

Querying SQL: SHOW CREATE TABLE `news`

News.findAll()

Querying SQL: SELECT * FROM `news` `t` WHERE Iddomain = 1 AND Idlanguage =
1 ORDER BY NewsDate DESC LIMIT 3

Querying SQL: SHOW COLUMNS FROM `compagnies`

Querying SQL: SHOW CREATE TABLE `compagnies`

Compagnies.findAll()

Querying SQL: SELECT * FROM `compagnies` `t` WHERE app_type=1

Config.findByPk()

Querying SQL: SELECT * FROM `domain` `t` WHERE `t`.`id`=1 LIMIT 1

lazy loading Config.paymentMetods

Querying SQL: SHOW COLUMNS FROM `payment_methods`

Querying SQL: SHOW CREATE TABLE `payment_methods`

Querying SQL: SHOW COLUMNS FROM `domain_payment_method`

Querying SQL: SHOW CREATE TABLE `domain_payment_method`

Querying SQL: SELECT `paymentMetods`.`id` AS `t1_c0`,
`paymentMetods`.`name` AS `t1_c1`, `paymentMetods`.`type` AS `t1_c2`,
`paymentMetods`.`partner` AS `t1_c3`, `paymentMetods`.`telephone` AS
`t1_c4`, `paymentMetods`.`email` AS `t1_c5`, `paymentMetods`.`logo` AS
`t1_c6`, `paymentMetods`.`title` AS `t1_c7`, `paymentMetods`.`description`
AS `t1_c8`, `paymentMetods`.`working` AS `t1_c9`, `paymentMetods`.`image1`
AS `t1_c10`, `paymentMetods`.`image2` AS `t1_c11`, `paymentMetods`.`image3`
AS `t1_c12`, `paymentMetods`.`TitleEN` AS `t1_c13`,
`paymentMetods`.`TitleDE` AS `t1_c14`, `paymentMetods`.`TitleIT` AS
`t1_c15`, `paymentMetods`.`TitleES` AS `t1_c16`, `paymentMetods`.`TitleNL`
AS `t1_c17`, `paymentMetods`.`TitleFR` AS `t1_c18`,
`paymentMetods`.`DescriptionDE` AS `t1_c19`,
`paymentMetods`.`DescriptionEN` AS `t1_c20`,
`paymentMetods`.`DescriptionES` AS `t1_c21`,
`paymentMetods`.`DescriptionFR` AS `t1_c22`,
`paymentMetods`.`DescriptionIT` AS `t1_c23`,
`paymentMetods`.`DescriptionNL` AS `t1_c24`,
`paymentMetods`.`MethodPaymentDE` AS `t1_c25`,
`paymentMetods`.`MethodPaymentEN` AS `t1_c26`,
`paymentMetods`.`MethodPaymentES` AS `t1_c27`,
`paymentMetods`.`MethodPaymentFR` AS `t1_c28`,
`paymentMetods`.`MethodPaymentIT` AS `t1_c29`,
`paymentMetods`.`MethodPaymentNL` AS `t1_c30`, `paymentMetods`.`online` AS
`t1_c31`, `paymentMetods`.`account` AS `t1_c32`,
`paymentMetods`.`agence_payment` AS `t1_c33` FROM `payment_methods`
`paymentMetods`  INNER JOIN `domain_payment_method`
`paymentMetods_paymentMetods` ON
(`paymentMetods_paymentMetods`.`domain_id`=:ypl0) AND
(`paymentMetods`.`id`=`paymentMetods_paymentMetods`.`payment_method_id`)

Querying SQL: SHOW COLUMNS FROM `countrylist`

Querying SQL: SHOW CREATE TABLE `countrylist`

langue.find()

Querying SQL: SELECT * FROM `langue` `t` WHERE nom = :lang LIMIT 1

Querying SQL: SELECT CONCAT(`NameFR`,' (+',prefixe_international,')') AS
countries, prefixe_international
                FROM countrylist
                WHERE prefixe_international != 'null'ORDER BY `NameFR`

Querying SQL: SELECT CONCAT(`j`.`Description`,' ( ',`c`.`Nom`,' )') AS
traverse, `j`.`id`
                    FROM `compagnies` as `c`
                    JOIN `journey` as `j`
                    ON `j`.`company_id`=`c`.`id`
                    ORDER BY `c`.`Nom`