SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413900 LIMIT 1 [ RunTime:0.004296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413900 [ RunTime:0.005662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531704,313355,541179,497250,1018590,613883,185681,262345,592378,852019,773412,855101,330683,634008,604575,875737,710706,61104,9725,502477,212745,907330,599394,428026,117551,1026768,904332,501672,123415,895941,103386,502892,718391,368246,103409,761064,733211,600606,172623,237869,471170,679981,901492,559395,524424,566901,551510,363066,292457,700160,893108,515660,1002537,280819,105210,77964,306054,828496,37930,22031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]