SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045598 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045598 [ RunTime:0.003929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674908,214426,161472,446008,651661,627093,768640,60482,374533,9506,263063,378291,533932,796494,554318,184459,899442,534170,1005600,510696,770332,618559,993938,437274,265658,104716,577256,57945,675400,389824,492367,426463,657430,659175,766500,137589,867211,608262,135199,431192,372545,537841,949137,1045326,946993,72976,429681,3528,3048,525648,270369,990863,1047380,880889,816007,375396,17579,440300,474851,656031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]