Paris Miki Australia Brand
Paris Miki Australia Brand

BAUSCH & LOMB

Bausch and Lomb was founded by Jacob Bausch and Henry Lomb in 1853. Fast forward to 1971, when Bausch and Lomb introduced the first soft contact lenses and is now one of the world’s largest suppliers of eye health products, including contact lenses, lens care products, medicines, and implants for eye diseases.


INQUIRE

WEBSITE










(default) 7 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`key`, `Config`.`value` FROM `parisau_web`.`config` AS `Config` WHERE 1 = 1 ORDER BY `key` ASC17170
2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `parisau_web`.`session` AS `Session` WHERE `id` = '466237d0a6605cc3c3fee91df37067d1' LIMIT 1007
3SELECT `Brand`.`id`, `Brand`.`code`, `Brand`.`name`, `Brand`.`details`, `Brand`.`thumbnail`, `Brand`.`photos`, `Brand`.`website`, `Brand`.`style`, `Brand`.`kind`, `Brand`.`popular`, `Brand`.`status`, `Brand`.`create_user`, `Brand`.`create_stamp`, `Brand`.`update_user`, `Brand`.`update_stamp` FROM `parisau_web`.`brand` AS `Brand` WHERE `Brand`.`code` = 'BauschLomb' LIMIT 1111
4SELECT `Category`.`id`, `Category`.`code`, `Category`.`name`, `Category`.`order`, `BrandCategory`.`brand_id`, `BrandCategory`.`category_id`, `BrandCategory`.`create_stamp` FROM `parisau_web`.`category` AS `Category` JOIN `parisau_web`.`brand_category` AS `BrandCategory` ON (`BrandCategory`.`brand_id` = 1181 AND `BrandCategory`.`category_id` = `Category`.`id`) 111
5SELECT `User`.`id` FROM `parisau_web`.`user` AS `User` WHERE `status` = 1220
6SELECT `Category`.`id`, `Category`.`code`, `Category`.`name`, `Category`.`order` FROM `parisau_web`.`category` AS `Category` WHERE id = (4)110
7SELECT `Brand`.`code`, `Brand`.`thumbnail`, `BrandCategory`.`brand_id`, `BrandCategory`.`category_id`, `BrandCategory`.`create_stamp` FROM `parisau_web`.`brand` AS `Brand` JOIN `parisau_web`.`brand_category` AS `BrandCategory` ON (`BrandCategory`.`category_id` = 4 AND `BrandCategory`.`brand_id` = `Brand`.`id`) WHERE `status` = 1 AND NOT (`id` = 1181) ORDER BY `name` ASC551