SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840908 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840908 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220107,534409,265234,676645,165688,662976,1040920,565887,553949,1003678,258677,556208,238958,1005316,82006,84677,399201,106868,64098,967913,230174,415022,471248,805361,107064,359588,496656,616820,464908,813676,355012,690946,684458,535290,1033599,277860,353738,101569,763203,92108,414957,252254,794970,327083,507884,448159,821285,670070,833107,706664,217163,902786,737502,78971,6346,600412,425210,1000173,383301,504303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]