SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450122 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450122 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200043,505454,449425,318118,620682,135438,733486,933285,570389,408322,853829,785456,748983,451934,721206,28907,791869,118288,731228,669588,336965,478555,615269,402867,274190,842372,728171,625686,1035657,347858,495542,786684,565627,939205,437704,140841,630902,174659,525646,445285,803012,680886,743343,677260,417173,185517,135249,790553,410051,976049,571653,173326,775460,934561,445490,689320,839538,770454,543899,931955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]