SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488201 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488201 [ RunTime:0.001389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808590,1031997,593819,1018716,780905,924135,128903,180267,859278,819898,972906,854889,433463,403580,653668,415694,572802,414146,377306,1008563,486969,912880,402169,12963,758527,278670,892556,601899,227064,548508,349150,207099,254128,223411,183907,158027,723185,144873,623487,584211,211622,669905,387694,413411,806789,863153,8236,144389,105103,720668,110801,782940,830395,1001325,1001864,681910,899666,55252,248566,42782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]