SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20114 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20114 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385633,80783,290659,109743,691086,865511,25357,866977,30202,1023443,284205,495468,867032,718066,513235,756578,523344,700276,681213,124751,98918,478235,896713,764598,308680,346180,779567,632101,142796,673134,160332,921187,629544,548748,1006583,230745,75997,593474,640409,303045,656868,780217,218470,82228,654311,883319,843390,383215,692999,860773,295136,643368,879996,302186,426678,269664,112763,461587,445085,711077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]