SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335881 LIMIT 1 [ RunTime:0.001202s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335881 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20576,398340,443962,783544,402391,558677,125777,429312,707063,15260,450564,784016,76933,1005047,19788,371282,58275,685681,556003,706437,376271,750657,58147,1014902,371914,380052,814649,779961,623796,289900,127100,609661,21209,1044704,864936,881479,402340,965530,707006,685283,715902,887923,964020,712940,679651,488,508267,99168,593169,235812,124543,126539,415128,23524,12717,70261,631244,9136,726060,405794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]