SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526850 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526850 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108357,743557,63288,559141,578165,280194,93897,966846,462124,534694,643339,819752,543990,190125,348420,808294,332381,554029,458081,597892,602615,782905,73098,963970,808408,497016,45808,17428,615737,197867,152828,880141,678372,124143,441197,571518,374444,207849,100911,217071,565929,88207,375958,309162,220671,391520,553054,644932,987977,762889,783891,503689,753804,342133,451032,574146,89904,954311,744602,60232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]