SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309281 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309281 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405350,248439,20926,254592,171346,1000013,581918,917962,478405,1032310,516712,488108,249778,713924,704146,1004096,797021,177532,481376,604805,581284,305344,150981,815194,463679,768312,622666,159935,42845,226961,69109,762509,125111,145467,52661,295185,725451,626043,78177,685664,439606,360652,45381,749920,485368,591814,208539,296187,307605,946515,72136,317244,837441,917991,16656,150189,589763,392963,751359,595645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]