SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803012 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803012 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387465,77383,336916,186285,604637,952932,150004,414079,377475,491731,763298,1017800,270263,706815,410540,914009,303612,323086,825534,969002,702288,897467,667038,763423,387381,342880,876375,50647,452479,410861,315401,987807,218529,238722,742240,942722,767226,457668,957063,913045,437932,535185,571517,979257,358099,284909,796797,627526,771390,104414,236097,931101,856660,728543,905154,944935,136351,504459,1031523,570806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]