SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761948 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761948 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166568,801087,919492,149745,141373,769268,240060,1010600,218686,158307,343651,523793,1000257,374750,711976,1022167,819297,278073,1042479,234641,91161,499856,260760,17981,321619,140641,537488,58566,66835,943166,717530,350867,661881,433983,524006,403657,645241,986867,415533,964520,270319,112409,743697,435331,790800,673371,167488,724271,452675,298799,877410,872660,53147,1011105,1042193,689746,761766,88098,376680,460672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]