SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203864 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203864 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694009,90607,502535,212270,456978,227794,35978,921056,709091,932915,567199,936820,564985,282563,512369,71556,349348,775266,507791,856461,555550,648158,311117,966974,622118,3724,177915,877840,760413,909319,303396,595585,808283,218458,467129,535314,934839,112617,51460,571625,668975,16842,278456,888602,418749,135394,936301,160366,991108,945881,256350,615903,970404,436477,340882,366838,721184,211397,573247,544970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]