SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761028 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761028 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793871,873536,578173,194399,809196,1028213,574271,963495,197837,223991,836585,777847,63459,161469,337404,12640,134251,771716,566293,675126,909517,503990,244827,22502,802480,409140,712932,236273,213305,570697,536489,672009,842414,728417,680343,428348,161900,92309,590277,608601,636613,972372,133433,584654,631020,348643,146480,1022776,510821,979065,193317,401896,586,24457,15579,836202,529572,957762,790547,243785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]