SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458091 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458091 [ RunTime:0.005287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748504,521700,855932,99912,922843,149487,247203,760301,990365,930700,225911,546483,945376,318343,4498,293550,505454,482146,106945,28599,351712,439410,133064,1011651,668819,957502,411332,185081,864969,883659,450479,995588,377348,403275,402593,655020,389834,493069,527502,419416,833650,236240,553601,493602,464199,1042803,750283,329496,113322,116838,35714,503498,720003,227483,783703,176007,233672,433323,846320,422994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]