SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401180 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401180 [ RunTime:0.004889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852788,773370,688160,114587,11731,262891,336739,316425,985124,266338,150114,295697,445173,375013,809771,780532,95516,825113,559508,318790,459391,87589,934199,839741,278288,853419,787530,495953,486347,259872,589694,643401,305325,566773,390046,164586,1034938,488170,817821,385049,304439,455496,987978,587074,172500,643921,822098,746828,871967,116117,698116,714982,260801,854807,703613,527283,883884,375823,563655,942932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]