SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 160418 LIMIT 1 [ RunTime:0.003389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 160418 [ RunTime:0.003774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935100,127536,587220,510109,368038,1024142,227304,390548,250018,447666,994912,984451,150264,250339,92929,309011,250054,912090,28466,276387,149277,301624,393070,913636,127641,643135,725616,647457,208160,865495,432466,988064,663366,976564,373816,511025,349306,91530,55003,433533,509392,1010009,443256,741704,578440,8552,63023,419270,704644,872375,613711,729615,396738,902361,368988,57424,143513,228628,584991,337746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 160418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 160418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]