SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418596 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418596 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78728,1046649,162739,160271,291615,92149,694389,740003,9985,76474,713453,801693,53233,175864,282519,615478,9644,373639,722914,63967,727952,250230,733834,91122,478986,286739,778115,578514,989546,927365,1034770,496104,207896,418182,889006,587539,731504,489253,999900,617662,992778,852783,1022618,306936,184369,1031133,493729,133753,227515,20827,344504,523043,652843,716988,51027,809078,426365,1023268,818096,649422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]