SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145133 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145133 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429600,990125,21318,104606,195659,181814,40988,830225,846886,403253,884026,219576,467750,904033,792009,364871,338030,70723,409581,69134,130987,223748,93912,317885,596526,143722,791807,121868,29133,752980,478908,245979,496173,468907,528790,538173,1031969,629417,429420,6651,80685,970441,387401,796901,65814,178926,268497,699247,784641,332434,322676,82207,582505,332080,836160,370479,1046429,95336,1015820,757713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]