SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286068 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286068 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255202,683048,331649,36563,477588,747082,613401,420357,554468,961103,175307,969438,437533,166127,831092,244353,775740,110384,655240,203316,862758,14955,908460,1029390,24464,110263,240861,685897,1023601,891928,770970,487248,452533,686302,1028788,688530,803140,104403,253169,301409,701843,1031959,989622,503393,818268,18518,61235,294481,42531,20446,208381,173472,261258,803204,296210,582423,354071,391472,772102,242066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]