SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470508 LIMIT 1 [ RunTime:0.002608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470508 [ RunTime:0.002366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856829,387293,366133,19727,831511,926382,441762,984233,540120,934468,924426,416706,438108,687077,382629,305404,515187,182278,811292,431649,554450,430905,169513,230072,170914,539795,921022,120271,1035591,99649,867984,461903,908656,278332,117345,752362,831172,655656,896725,567944,556841,1519,396982,660019,359223,978864,535700,421482,639156,345219,770392,582549,641035,376668,15086,412446,193546,244106,183970,427643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]