SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41171 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41171 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414889,451650,556750,591067,368476,74,507484,350523,355616,13261,396585,473962,635668,432020,1015786,310594,792409,208346,723139,962049,2349,454033,289688,816146,878255,20373,90459,306433,567704,806487,849515,279545,571636,908024,402311,628642,1011495,234032,81878,977086,857087,281670,625183,582920,133724,52874,80675,216316,666782,106250,420271,694850,678487,382878,125204,1002892,118424,830718,62279,529491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]