SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556984 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556984 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436307,86310,941160,108456,70043,553024,378525,324319,556913,51435,608021,289159,631124,52947,123024,916430,164272,242285,460897,348379,159444,824228,497147,736597,631954,974712,976159,585103,500527,554259,878493,401764,1005417,178806,112305,549765,217883,240933,101985,739122,432232,7614,329884,380904,146485,259017,772770,945621,235120,98990,153414,915504,858190,409799,286044,771713,253608,340180,760468,882208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]