SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036116 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036116 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312185,158757,56906,777174,911761,735646,209710,982130,728271,992253,303463,362100,321404,202432,423853,743081,158326,627560,50781,999463,492200,797799,163754,135068,945698,817205,358705,1016443,857608,336038,134792,692930,857529,907458,914757,856397,361884,881783,61197,241992,411447,249799,537650,1012148,58751,734860,496323,476649,932420,115160,148958,1022656,584094,695614,314299,927279,21523,890729,864719,109570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]