SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520541 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520541 [ RunTime:0.003840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892629,1024630,916236,214274,303066,562644,639135,638420,69665,783115,623942,686370,928972,64935,168874,629083,102305,454704,869908,456537,820343,193508,19049,613891,815094,1021704,784271,218542,419008,409753,171417,1029458,496528,732886,821257,164096,949929,603037,660521,557407,1046878,169326,456006,489182,384642,775986,204542,380453,864766,97933,843605,724853,538309,495914,802374,971616,396783,596936,645140,73753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001876s ]