SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447067 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447067 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518813,154296,540049,311477,213234,174170,493401,1009183,327595,524534,890382,1022920,345580,466672,536219,79286,482050,400917,257629,425062,615390,289428,875594,653117,404895,203110,419108,361995,862006,809130,557432,895566,55649,325757,91890,898642,211665,489341,657844,380334,501423,152549,183800,1020451,78453,538861,287449,191373,599130,258368,23761,24136,882402,428781,985334,449224,399147,157764,739087,794703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]