SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563323 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563323 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72112,240886,928003,627383,432055,386296,789684,15964,461630,902919,1012288,452252,301965,230718,581151,244822,786640,136352,284537,870387,589394,10203,342930,630430,290291,386778,784600,216533,417791,575924,919885,997352,773304,753188,1027290,856119,379506,114493,578154,455702,920231,847136,65777,738845,740690,920797,262165,18877,889042,254199,79875,238217,922429,773139,17977,232848,313499,1030563,810690,1024705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]