SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598510 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598510 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835507,251960,666142,235645,840088,244007,499038,89634,197349,315431,464195,741117,144639,634357,972523,977803,254839,280219,622134,811553,577381,363043,770772,321313,514918,799290,916491,100087,446473,37814,637487,874241,493625,640916,678753,482047,368396,211443,350644,877593,865049,861778,915524,354535,9722,604318,696168,223617,609664,761050,763039,787926,718022,135389,797272,151340,10079,678134,1000025,579663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]