SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532830 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532830 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443311,331293,174539,192683,105988,405875,427421,578835,383563,347223,154859,183575,215117,608193,865055,751679,596089,329736,956656,556073,611037,669273,1046877,645788,998806,102252,844962,786269,16116,924093,276635,423919,584902,687885,85332,366021,529269,384576,914440,152101,51820,98270,405491,931700,486675,763541,551724,376698,257148,350867,750579,631109,708291,932851,916232,877900,1031602,1008318,531176,578740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]