SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564276 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564276 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35798,659443,473011,997025,616411,361672,769553,504353,234042,256562,1008,516822,845241,335144,17766,701033,685525,833288,37621,55621,861913,11034,492396,743441,883900,19775,93103,698543,501941,421924,745204,641812,791830,739012,958890,1009762,324449,240475,952959,688778,132075,787990,127380,804839,886823,181848,917970,724600,34873,747735,853609,587143,194884,843468,84550,535387,256156,874115,666753,639048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]