SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426035 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426035 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187843,98815,972110,759576,365802,846301,236025,507301,711707,12499,727767,423576,124112,951014,129926,266626,284887,181922,268444,838012,29446,428602,291234,1029667,330807,390120,178541,428535,31714,352930,874341,365683,718683,389247,712806,911014,58867,1013501,413382,805526,858487,683426,589792,393454,590712,940289,789287,990698,802279,1016898,270343,492528,692525,308762,291996,861079,834124,757939,1019061,465112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]