SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507335 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507335 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40223,645665,452304,611359,687616,979046,485191,113058,833412,196222,47096,367479,221346,985765,374605,392661,359763,346202,429427,629324,342889,198219,321151,285349,618028,881557,402530,300883,663003,920278,153445,621909,644349,914076,741665,356760,556412,561384,51189,450052,322890,405074,626830,432511,788194,401885,84070,506744,953857,317942,1000254,266467,276636,602288,1016650,706215,647303,1024463,558699,722061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]