SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592014 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592014 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282627,528375,226933,50332,1004630,16916,512082,466105,504969,134275,296062,191554,210371,861921,628290,61874,3508,4201,820387,946093,300309,15383,516547,792447,558414,1010968,517655,707735,916024,978774,153880,365304,785025,260880,135225,801158,63708,734681,1020599,333878,23881,548849,807018,407989,674426,887384,1036297,1000909,188891,723135,362280,196070,733074,1042440,61790,1036256,409559,473249,236299,25073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]