SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 288430 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 288430 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253681,332824,740118,642387,528684,612820,243367,704485,544423,204862,728586,634457,453633,676709,418971,406619,880072,565281,731301,854412,550679,270900,767606,29774,657775,224302,371893,166273,1026106,833971,492661,222093,148471,805442,80291,200471,742146,291017,550612,291233,974559,462138,192198,366376,113967,939650,566417,872458,185654,1018623,239327,895314,659183,976493,25046,56731,172532,756670,782328,137882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 288430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 288430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]