SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684061 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684061 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714899,965049,188589,165818,41161,5083,547460,1042631,1018725,236661,837038,1028852,424114,668670,556058,989344,120582,818004,483087,455393,459886,919803,770562,947089,249921,118076,391264,933981,999909,224767,460731,526939,365976,927625,190452,1022070,229674,741894,527839,659895,357341,993819,877668,452143,859917,539045,335840,1000978,929257,234119,694745,48016,150493,630346,417683,75464,621376,1045026,872999,124516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]