SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340075 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340075 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183982,378669,70459,444006,789869,816619,1033706,647696,750258,468989,611095,141499,829557,981102,10859,885033,776951,2793,576212,32833,332444,723351,474296,201161,19101,1043153,269650,426475,775914,92745,303889,848079,202280,534708,239482,800460,387070,1004604,799177,904435,916923,14272,901917,994504,912000,69629,787804,737300,924258,823057,333108,193867,966020,334478,512620,37590,435203,399583,731271,920746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]