SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591628 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591628 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417159,32803,480052,349228,566557,557987,988149,807605,854347,881892,461741,829753,490796,64641,768074,502772,481244,291381,995664,347599,920125,269584,12937,276572,561864,800362,388209,692950,591004,1005225,962009,269251,899870,761180,651930,552340,1013969,939153,481873,880547,413756,102010,315843,409126,657500,27188,215390,668924,597073,227402,836607,846904,523251,555786,518160,780390,903813,909703,669051,1040892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]