SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503428 LIMIT 1 [ RunTime:0.002522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503428 [ RunTime:0.004004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328685,633446,482150,134674,2764,264403,768135,456689,944442,970162,230206,817802,428391,29061,621002,859357,550055,739408,969190,206486,543093,927680,1011273,411168,284260,83926,232645,1011950,293853,338359,193447,260856,682876,619245,136304,711671,781839,441870,911702,263003,214506,397605,804773,521244,328337,408947,992472,436115,114428,238108,259743,268011,143622,41280,315139,974841,137222,537706,893594,745917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]