SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112288 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112288 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806524,205485,150096,924110,448014,703826,200007,660181,208520,90059,971652,197119,826496,394395,64407,52717,832654,851489,393045,879292,511145,949136,220860,833561,647301,88571,330365,693727,525367,361158,534764,300119,978312,310620,325560,270328,262116,771127,312222,728117,826231,665476,677097,419366,985660,178455,419609,815282,739706,602866,172372,927397,826639,833946,638080,410174,181928,361507,485401,381575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]