SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680424 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680424 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174638,888174,482001,549666,731237,136646,636350,759188,134508,242010,527748,964555,755604,474230,856109,500980,246283,55222,322948,650481,664671,214573,218737,541035,454338,480830,620856,618070,280236,998791,818757,852288,209848,303716,385568,212115,756392,873526,4758,226031,571548,906291,349637,620809,696084,658744,573001,696129,768277,369268,670476,937268,466814,30312,995761,648045,683215,867477,546964,818136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]