SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541122 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541122 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271894,611566,898206,309438,214701,814271,965556,999690,503538,664548,810011,788970,476810,935166,355314,860729,832237,892207,833555,342942,847947,296916,997073,793039,565971,420298,176865,363657,50002,413976,974318,109045,217792,1019532,801095,813523,518661,938533,684535,729548,639747,961671,465389,865469,798373,92971,477019,193045,1025943,591508,525054,985228,953674,105676,543263,35543,413107,387853,966723,618317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]