SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345303 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345303 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935667,59540,538567,397101,965940,871392,45914,594184,1030856,876367,21323,124053,706306,23394,871478,424377,429688,994716,260314,422130,838,578130,939224,267627,321145,56929,313388,249264,884240,713008,836671,531077,222747,714587,435558,38749,441467,444130,745946,976068,198771,238269,495729,257011,528070,237132,173751,868375,835643,114504,1010843,997475,851515,534779,993665,567632,64536,496356,148357,640829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]