SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559211 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559211 [ RunTime:0.001397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401592,98498,544325,295423,166551,295340,691917,109192,383758,220676,235107,358508,826962,280363,556592,843018,559314,818179,803467,85305,496453,5585,898824,509799,833989,868858,83100,485110,203431,933334,854469,303978,439383,506219,495401,806226,73702,961509,581334,608686,702394,548550,623873,273777,99792,179799,719560,948994,83290,453377,382260,693788,428819,468456,866051,214373,982575,1014983,1010385,334553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]