SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481209 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481209 [ RunTime:0.002041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945820,840986,792354,1045821,944440,519020,913229,677610,142081,88854,362893,479861,998610,147085,239826,844687,235342,728708,1018931,614870,841087,825668,241862,825514,210221,683190,701664,571057,424763,1009906,906224,1011954,163969,982902,169602,643774,632092,520468,557458,166548,689900,600070,826857,729963,209241,107658,739223,770764,994425,789884,127065,159292,763191,161959,749448,168827,19629,550246,250209,643733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]