SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559963 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559963 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325420,995611,944196,888314,1003800,705931,46403,341214,442494,221089,170510,610342,581926,131484,1025011,911813,166045,670623,56009,1034046,958248,145135,791824,1020759,995602,908333,945779,720206,498106,459793,163252,901997,553299,716409,231252,143214,590576,197520,1005899,91412,79981,752435,150693,678239,324268,930906,11894,760792,399756,233354,534546,29530,204430,302270,779787,63446,882736,897636,257226,235032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]