SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017692 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017692 [ RunTime:0.003353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962194,527696,500533,932822,448737,382066,988906,259540,965507,697666,734754,645865,695309,370188,622265,843374,621267,170786,718772,424060,807820,347926,972602,316345,898303,341001,787433,345136,73476,489183,996548,635689,887136,420648,595693,71133,404637,871992,228917,549273,286592,192458,966202,565737,412433,105917,693221,152394,439504,467610,154904,638136,384504,263277,749048,418445,812159,258336,435345,1045094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000990s ]