SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408098 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408098 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100466,35380,289589,727537,520484,845398,956642,80859,431508,236237,248570,373525,701779,48877,445568,865850,113628,1001504,771129,158185,477296,657980,133451,250008,764503,424533,1046939,681698,523123,266007,552078,243002,227106,7457,640746,589105,194984,41177,836358,781537,712285,523967,980799,125061,809062,654850,713682,806436,837386,639813,797380,1008924,767852,825106,117527,638861,1031515,464002,892623,208195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]