SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49142 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49142 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332604,786905,988648,620557,850419,551597,83238,789820,1010182,757809,1025840,153776,552452,912868,39871,514344,264126,792406,823468,421809,791373,209851,699762,891000,453606,644744,136444,505744,852351,227061,1362,344576,187218,433530,401548,927737,602942,750886,357004,867693,325528,787627,750649,640173,521074,313491,674362,148720,284317,345876,219059,134773,254416,208291,709335,625022,877766,2469,447474,308312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]