SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 880948 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 880948 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469909,365780,559954,169762,639957,665859,691112,246825,984811,720242,231428,823039,27750,805586,256142,985139,703247,744643,200437,813441,1043494,740492,294291,901517,366038,162377,802045,237479,634129,1004294,474701,262993,371812,580984,238448,589252,977620,767034,397480,993649,511519,880902,430274,944382,822764,239039,898768,945004,323409,899239,402196,365992,218786,149139,894761,375624,137900,735025,756561,645747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 880948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 880948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]