SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900038 LIMIT 1 [ RunTime:0.000964s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900038 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005724,1016357,884612,901838,170518,590083,640400,269864,418171,1024632,27834,893791,349722,774293,773072,328262,461220,930444,643340,754746,260331,955516,57526,488557,501997,433383,164481,985119,989748,731651,17081,65640,217262,616528,341209,176509,829594,484188,968843,258014,784329,167425,1025221,578466,596942,683883,520140,142858,902327,261177,431126,874981,378861,643908,395331,844794,667377,331682,847595,460945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]