SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349230 LIMIT 1 [ RunTime:0.002464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349230 [ RunTime:0.005752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535272,418757,635778,281720,910253,523200,123606,229575,1044355,532864,84205,991819,391999,1011165,259290,843711,626904,444080,288383,721479,405380,561329,87015,496543,992730,978042,642871,75321,921862,227457,486941,252039,1037917,293076,248929,665614,414468,76228,932921,905633,183677,339469,655305,59837,97920,555478,657296,505180,883545,809989,749269,121567,58202,7436,677969,328576,710510,575383,1034099,723379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]