SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455227 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455227 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968860,137484,130468,541908,672251,635352,223378,432337,485254,444479,261383,226051,160419,924873,985957,120252,496531,933852,528318,746876,825621,14479,131027,1007999,958901,904909,860621,513868,209936,366951,73427,915573,162292,755285,825554,75171,54979,1005057,733030,300025,608115,543304,303398,426316,461891,1025960,163928,130646,513318,763655,715155,497909,1040347,786985,690508,208111,709200,258098,982896,791235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]