SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940013 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940013 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24531,98684,507691,731465,580869,278791,706331,134568,1023896,250077,124313,865679,976111,551398,142968,453656,29035,663086,552136,383075,186409,384390,997432,148621,516557,51092,1035301,584909,452815,1009523,49108,358286,396047,316046,750605,722398,9593,626773,974461,698085,487323,736610,725600,107444,543094,175633,1019795,104322,633736,655083,580098,483302,959406,832836,520226,48124,11138,838803,170304,122385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]