SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478630 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478630 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398384,635575,865716,999513,955559,352883,618965,874872,860140,424601,200422,211806,108215,1025879,122016,293098,48733,673010,359894,380740,782861,875694,848055,404065,350786,79392,221281,851236,373331,654025,270529,107,300092,157105,236773,409746,800350,851369,294500,410893,428882,182015,53434,910727,176951,1027857,83789,37399,844909,82905,839077,835952,485297,112107,297603,362770,497587,1001994,890037,1012795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]