SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498661 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498661 [ RunTime:0.004962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426531,220852,894693,610743,478163,578197,242609,468461,46480,528709,746897,568240,797615,248185,677243,275859,1000934,426555,414822,936637,841202,808057,284931,444346,737329,383907,953177,78859,164925,644037,853701,787476,72866,555382,982396,866696,551524,462456,972142,962080,84796,460656,477349,755094,465656,117827,586855,880753,611322,874334,823768,1029626,412976,601972,610525,361740,596918,688612,629314,74441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]