SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026431 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026431 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629905,285890,779604,700541,164727,197070,120305,680213,1012030,22350,37924,550737,193945,33644,496709,838610,232677,498421,672110,355863,16694,913411,300387,74361,439878,508883,847957,27173,606229,601286,242355,856183,507825,296004,797329,760745,952557,616001,251802,1012942,764829,456754,750875,283935,974686,686779,957235,248788,679445,972372,882671,741486,283734,623221,641597,1012906,694359,417074,769091,346220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]