SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396994 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396994 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415364,920614,397952,660776,79252,151280,518604,589723,783496,743178,171360,988662,1025430,88703,522531,685110,73593,73681,545902,193169,783500,928102,851333,798943,794115,856786,705006,130191,284559,211474,832873,826803,578158,135646,1025256,566414,134800,323360,451003,111642,979073,227505,879567,1025805,695474,953038,470333,441607,738284,693136,256853,248593,718131,218407,582047,724143,957433,767787,482504,989299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001520s ]