SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494451 LIMIT 1 [ RunTime:0.001588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494451 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902023,123568,143604,818383,652335,37258,664417,1037895,259611,686919,701388,595958,924475,198963,639998,154817,252201,219660,674516,589082,222681,910202,165499,467759,622289,27765,168634,632833,540198,390047,618976,379879,355889,137638,795161,509527,862577,1018823,98119,452818,311243,260162,956094,107951,421055,868880,826891,293674,456510,423985,594272,136290,424068,445243,315432,20259,837045,295143,266741,910436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]