SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405261 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405261 [ RunTime:0.006113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757746,15511,307503,301491,601009,912584,45346,800780,519048,900214,10009,583961,108487,576973,276443,124362,822405,1007668,116933,722353,993359,480010,370450,670855,485925,640740,27833,888942,555726,738801,747235,244691,239039,680362,422724,577793,524757,648521,661521,1039162,230206,911641,225545,33059,393501,233863,93783,941348,206189,445894,308134,653738,513808,40047,173254,1037175,485560,433030,311069,140265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]