SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243438 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243438 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362036,44,271332,703206,143007,439056,976182,829750,661720,841919,836005,295583,24676,146380,58486,449027,265571,87744,350065,135531,395685,903918,265588,697889,398734,1008025,571005,567550,522836,463560,375633,780894,505658,586460,492170,467320,458507,976099,768904,510838,110269,539019,637373,72244,189280,441019,341671,1026009,886002,74167,659674,677625,266946,505625,886061,422493,198799,757296,704540,289183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]