SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526455 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526455 [ RunTime:0.003436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603796,28411,417159,765241,205120,920744,654819,521560,483286,1017096,515055,943864,442765,353923,987143,161206,520940,20361,262483,526307,830909,434036,852023,248291,585350,292911,114316,344898,504873,591115,820927,832603,318914,106973,650098,899842,850845,647840,692988,615767,419150,130323,189006,13458,230292,523527,394605,646727,194233,258533,646883,563359,560975,340229,9750,344411,937533,103393,35179,106408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]