SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449010 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449010 [ RunTime:0.002189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5216,152603,445513,992612,358571,102133,838660,294222,824589,164316,334682,514652,371056,637317,258160,614242,407538,85232,568126,1024489,865670,993604,575273,640122,925043,511894,630340,189292,193684,220419,521454,713593,723588,953899,108309,419155,800278,991647,330235,237903,561590,248823,500982,628426,486006,339808,791906,758835,592920,41990,220883,1026980,351851,937722,391038,532887,404146,472064,6441,881623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]