SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459814 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459814 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690361,275059,433516,797491,459270,1016189,16827,650284,701197,406069,269612,852927,434008,662110,847524,770509,22882,404864,430650,199241,774053,669634,624972,1024484,248615,854156,383651,419479,816418,607218,938368,948363,82945,1008051,931247,1028996,838532,57094,196166,377318,164081,133153,313736,834791,140761,219331,784670,929176,525404,650888,82388,833457,336756,792110,495546,741202,794039,848575,400023,615820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]