SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046458 LIMIT 1 [ RunTime:0.001530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046458 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802418,488528,709591,381600,817979,55287,833086,393924,827568,861330,23239,255020,533524,548951,514396,812202,127405,890846,949677,844785,412548,117309,5345,754736,860623,317439,966917,657550,424839,983782,52148,62566,732436,442395,269273,343370,83335,348686,764158,706754,260227,61520,649052,1026214,535453,318102,97779,359076,728859,316593,1000975,731141,395205,499093,32233,619033,352256,279910,742419,803557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]