SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419230 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419230 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196347,822724,188544,335355,369431,158928,818591,471521,956344,790939,483848,992828,788055,315475,315875,429637,673852,27303,34747,184143,992576,682744,935889,747459,875869,283916,144116,809684,600081,634834,143919,215450,443518,906378,829967,280157,677366,486105,217325,664988,112142,532256,603901,102036,468271,753988,810409,145695,555794,198410,759534,922960,1035191,810083,978295,166060,168661,469148,867915,72662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]