SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047464 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047464 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204560,316458,503407,59951,606982,692571,292179,194403,739263,846936,117785,730213,861270,412753,298610,625144,880930,1028756,695655,413419,386080,108529,922669,133786,118728,738673,681784,269501,452808,760168,538387,707919,577224,440959,144152,450018,503463,877541,974007,532866,632354,854803,110541,623457,421109,629567,625060,556681,618559,286555,987633,960519,749115,679153,412989,367011,147831,89039,726206,704589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]