SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199862 LIMIT 1 [ RunTime:0.002590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199862 [ RunTime:0.008105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678856,256427,424632,191757,119576,805776,38498,301079,925911,234928,725311,128514,396435,341741,719564,770039,199167,350290,1012202,383182,619236,813061,503030,453601,139598,480095,1035090,102764,422213,487272,878455,459504,455564,285574,996749,135104,739501,729322,41322,1010393,845779,353816,902631,199702,559170,121796,131775,785281,992527,94666,833434,29565,491743,387805,697977,626641,272384,916999,908771,138723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.010757s ]