SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020266 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020266 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003343,459391,211088,214088,228304,565958,188090,791621,371764,991017,940533,474597,982206,922287,196384,173065,641919,917473,890642,234667,996975,722499,220620,680479,265296,590202,861670,794821,398567,1011363,467821,178023,942765,81027,376026,686574,521472,769680,270619,525048,903043,311240,236307,499050,403505,177383,884935,716729,129117,592226,626616,211167,570560,290054,781072,977840,734986,717034,648757,541432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]