SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030531 LIMIT 1 [ RunTime:0.000643s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030531 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41875,575692,896974,669565,451562,920922,366932,27356,567663,1039008,837302,132065,1013354,122621,22813,868605,321942,192280,172735,370438,788401,709614,508875,411460,1040732,640295,703827,567132,403916,224102,227096,250779,246029,928313,38449,235912,79845,640511,28710,959159,875230,838841,736098,749148,108815,514848,509238,749056,191398,78615,469896,119676,470618,778108,277026,165404,643655,132160,819321,187132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]