SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405141 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405141 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33512,980650,623644,746779,305093,823939,79229,321752,868928,273078,377823,414682,1031282,420186,534005,585586,773755,488264,863584,417644,956130,1029919,743125,523875,344186,887537,325253,92336,137657,945471,410499,169543,923781,212060,209358,398807,662986,928468,96248,257606,440380,70038,133401,985438,852314,414278,270189,394470,72173,48092,344209,820467,567302,162486,758925,330112,556906,684202,773584,977804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000898s ]