SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531410 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531410 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444369,132143,870689,274948,444395,842779,144455,442863,422503,370316,719594,967374,9311,776612,551123,835086,549086,221852,114331,480045,223582,524225,806636,26258,992183,295235,661518,987585,660900,134427,649547,145558,393078,823976,796042,992284,204329,384071,543223,400541,707385,745161,329883,14347,264150,114379,550063,545061,303448,675061,215451,340443,277936,89287,814812,714616,292004,1008597,293938,27044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]