SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411383 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411383 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691988,996096,197708,449960,231559,1029303,784330,654313,577212,910015,469724,356095,375396,255207,620416,802160,247427,269387,188194,471348,76198,608734,578858,1013448,143601,147629,296266,918560,585292,408876,35324,1038089,392806,285662,546654,334068,86470,711264,967015,596244,655686,589990,663975,938236,501063,995168,400222,437262,51672,706051,419571,54302,849342,812069,696738,659448,214958,500430,870366,448341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]