SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39008 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39008 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036869,427349,975147,868256,561026,385477,959851,1016279,176657,945300,468948,76116,971852,999465,766522,948060,135559,327580,186372,996131,785954,1035342,755011,661379,197343,124615,265471,27637,593873,408475,197195,42517,655569,322152,508465,772875,966647,295321,790424,782781,350357,723866,891414,280307,175694,343722,693568,278975,533195,117069,712001,424098,911532,234924,627273,332283,510168,25549,452099,518098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]