SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044091 LIMIT 1 [ RunTime:0.000987s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044091 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485576,48332,514649,87223,513501,948224,469658,897758,155659,921589,107542,371543,696625,770340,797553,113148,1033113,736320,295481,416829,699134,127123,65524,495354,207150,765573,806430,791472,384835,354611,508362,788712,127568,826401,5753,184342,1016538,510947,167867,691649,802613,241661,1043159,873493,569816,455105,1003095,581927,825357,922507,1759,896559,1000927,721082,751326,988789,418023,697263,552322,510478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]