SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4897 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4897 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394516,174507,318503,746201,806249,729702,316478,178919,766917,679089,503680,994819,821442,517114,988379,191715,322753,423701,136661,488718,309143,948743,471211,529435,347736,350682,892663,553592,496000,1009683,708202,230936,603777,418225,735370,954146,401207,810889,634568,451955,138269,103856,353277,868643,518363,647649,465284,458692,242752,20274,154933,1033017,424136,224515,369560,961896,853087,397865,187928,577593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001768s ]